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.

[javier_rios]

Hi @darshanhiranandani !

Yes, the same expression works for Designer Cloud

On my example below, I added text using a Text Input in this format 01JAN22, and use a formula tool to convert the text to a Date data type.

😉