Date Time String conversion

[RudrakshPandey]

Hi All,

I have a date time string which is in 01/JUN/06 12:00:00.000000000 AM format which I need to convert to date time format in alteryx.

Any leads will be appreciated.

Thanks,

[binuacs]

@RudrakshPandey Try DateTimeParse([Date],'%d/%b/%y %H:%M:%S')

[RudrakshPandey]

Thanks @binuacs 

Thanks for your reply, however the AM and PM time is coming out as same. The expected output would be 2006/05/30 23:00:00

Please check the attached file

 

[binuacs · Accepted solution]

@RudrakshPandey note that the alteryx accepts only the YYYY-MM-DD format as the Date Type for any other date format it should be string data type, if you want your result in yyyy/mm/dd hh:mm:ss then you need to convert it into string type