Hello everyone,
I am stuck in DateTime tool.
I have date in the format - 2020-10-07 01:35:48
I want to convert it into the format - 07/10/2020
But when I do this using the DateTime tool it gives me an error - DateTime (31) CurrencyRateDate2: Cannot convert "2020-10-07 01:35:48" to a date/time with format "%d-%m-%y": Expected separator '-%m-%y', got: '20-10-07 01:35:48'
Can someone please help me with this?
Solved! Go to Solution.
Hi @Pramod91 ,
put on a select tool and change the type to "Date", this will convert the datetime to a yyyy-mm-dd format. Then use the DateTime Parse tool to convert a date to a string. Then simply select the format you want.
Hope this helps.
M.
Hi @Pramod91 I mocked up a workflow let me know what you think?