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
Solved! Go to Solution.
Hi @RK13,
Please see the workflow attached:
This formula should work for you:
DateTimeParse([Field1],'%m/%d/%y')
This worked. Thanks 🙂