Hi,
I have multiple string fields of date & time . How can i convert them date and time format without using date time parse for each fields .
I tried to use multi field but does not work .
Date fields : 20220101
Timefields : 080101
Thankyou .
Hi @praneshsapmm Can you share a sample of the data? Typically you'd want to transpose the data and do the date conversion once, then crosstab back.
Hi @praneshsapmm ,
see attachement here with a dummy Substring function, hope it helps! DateTimeParse function works great too and I did a small mock up for you.
Good luck,
Oly