Date format change

[RK13]

Hi Team,

I was trying to change my date format from 3/31/2021(vstring) to 2021-03-31 with date tool. But I'm seeing below error. Could you please help me on this ?

Note: I've multiple date in my data, above one is just sample

DateTime (27) DateTime_Out: Cannot convert "1/1/2019" to a date/time with format "YYYY-%m-DD": Expected separator 'YYYY-%m-DD', got: '1/1/2019' Record #2

Thanks in Advance

[Emil_Kos · Accepted solution]

Hi @RK13,

Please see the workflow attached:

This formula should work for you:

DateTimeParse([Field1],'%m/%d/%y')

[RK13]

This worked.  Thanks 🙂