Need help to convert Date in String Format to Date Format

[rdelmund]

Hi Everyone, 

Need help to convert the Date/Time Filed  which is a string type to a date format readable in Alteryx. Later I will use the converted date to compare it on my other file.

Thanks. 

Rob

[RolandSchubert · Accepted solution]

Hi Rob,

you can either use a Formula tool with DateTimeParse formula

DateTimeParse([Date/Time], "%a %d %b %y, %I:%M:%S %p")

or the DateTime tool for conversion.

See attached workflow for a small example.

Best regards

Roland

[rdelmund]

Thanks for the help. This is very helpful it's just i don't know what is the syntax that I'll use.