Hi There,
I currently have a string in the format of MM/dd/yyyy and id like to change it to the datetime of dd/MM/yyy
Appreciate the help!
Thanks,
Solved! Go to Solution.
You can use the datetime tool or use an expression like this one:
DateTimeFormat([DateTimeField],"%d/%m/%Y")
AND save it to a string.
Cheers,
Mark
you can use a formula:
DateTimeFormat(DateTimeParse([Field1], '%m/%d/%Y'), '%d/%m/%Y')
The result will be a string field, date type is always YYYY-mm-dd in Alteryx.
Best,
Roland