Date Format

[fieldew1]

Hi,

I have the following string 09-07-24 09:40:50 and I'm trying to extract date and convert it to the following format 2024/07/09.

Really appreciate any help with this.

Thanks

[DataNath · Accepted solution]

Hey @fieldew1, can't tell if this is MM-DD-YYYY or DD-MM-YYYY. Using a Formula tool expression, if it's the former then use:

DateTimeFormat(DateTimeParse([Input],'%m-%d-%Y'),
'%Y/%d/%m')

If it's the latter then you can use:

DateTimeFormat(DateTimeParse([Input],'%d-%m-%Y'),
'%Y/%m/%d')

[fieldew1]

Amazing! It did work for me :)