convert date format

[topazz11]

Could you help me to convert this date format? 1/1/2020-->2020-01-01

Thanks,

[DataNath]

Hey @topazz11, you can use a Formula tool with the following expression:

DateTimeParse([Date]), ‘%m/%d/%Y’)

[topazz11]

I am getting an error..

I have attahced the file.

[DataNath]

Sorry @topazz11 I made a typo and left a ) in after the square bracket of [Date] - just remove that. Should be:

DateTimeParse([Date], ‘%m/%d/%Y’)

[topazz11]

I did that..still doesn't work.

any idea?

[Luke_C · Accepted solution]

Hi @topazz11 

The quotes seem to be special characters - try DateTimeParse([Date],'%m/%d/%Y')

[DataNath]

Great spot, @Luke_C! Typed the response out from my phone - had no idea iPhone keyboard quotes would be different!