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
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
Thanks for the help. This is very helpful it's just i don't know what is the syntax that I'll use.
