Convert a date from yyyy-mm-dd to mm/dd/yyyy format

Hi All,

I have few dates in the file which is a V_WString and I have converted it to date format using DateTimeParse([date],"%Y-%m-%d") function.

Now I need to convert the above date for example as shown below:

"2020-05-14" to "05/14/2020".

Can you please help me out?

Thanks in advance.

Accepted answers

Thank you very much. It worked.

All comments

You'll want to use the DateTime tool - as shown below - Please view the attached workflow:

datetimeparse.yxmd

Thank you very much. It worked.

Agreed, the format changed as expected. But how to retain the data type? Requesting to change only the format, not the data type.

I am also very interesting in using your tool, which for btw thank you for, my date is in yyyy/mm/dd format and want it in dd/mm/yyyy format, however it comes out with null value and don't understand why... could you kindly advise?

Thank you!

Manuela 1.1.JPG

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703