DateTime tool error

[Pramod91]

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?

[mceleavey · Accepted 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.

[JosephSerpis]

Hi @Pramod91 I mocked up a workflow let me know what you think?