Darshan Hiranandani : What's the best approach to convert data into datetime format?

[darshanhiranandani]

Hello Everyone,

I'm Darshan Hiranandani, I have a dataset where dates are formatted like "01JAN2022", which isn't standard. I need to separate the date and time parts and convert them into datetime format. What's the best approach to achieve this?

Any insights or advice on how to approach this would be greatly appreciated!

Thanks for your help.

Best regards,

Darshan Hiranandani 

[KGT]

Hi,
I'm not sure in Designer Cloud, but in regular designer it would be DateTimeParse([Fieldname],'%d%b%Y')

%b is the 3 letter month code. %B would be the full month.