hi experts,
I met a problem on the string dates format:
I would like to change the string date format to Date format, eg. change string date "06-DEC-2023" to date format "2023-12-06",
the formula doesn't work in this way: DateTimeformat([Date],'%m-%d-%y'), it shows: Formula (13) DATETIMEFORMAT: "06-DEC-2023" is not a valid Date or Time
also not work in this way: DateTimeparse([PO Creation Date],'%m-%d-%y'), it shows: Formula (13) DATETIMEPARSE: Cannot convert "06-DEC-2023" to a date/time with format "%m-%d-%y" and language "English": Month number is out of range 1..12: '06-DEC-2023'
Can you help with the formula please?
Solved! Go to Solution.
We can also use the DateTime tool, it is more easy to use.
The DataTime function is a very powerful, recommend you to read this.
https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#idm45271966381712
oh, it helps too, thank you!!