Converting string to Date and time

[praneshsapmm]

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 .

[Luke_C]

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.

[oly]

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

[Emmanuel_G]

Hi @praneshsapmm ,

Do you want something like this ?