Change string date format to Date format

wendyzjy

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?

flying008

Hi, @wendyzjy 

FYI.

DateTimeParse([Your Field],'%d-%b-%Y')