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

[Bitopi]

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.

[ggruccio]

Hi @Bitopi,

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

[Bitopi · Accepted solution]

Thank you very much. It worked.

[rituraj963]

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

[Tmanuela]

Hi @ggruccio , 

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

[atcodedog05]

Hi @Tmanuela 

Can you post this as a new question, provide some sample data, expected output. Please provide a excel file with only date column. Please do not provide only image its becomes really hard to solve.

We will be happy to help 🙂

[Tmanuela]

hi  @atcodedog05 , sure, I'll post a new query 🙂 thanks

[prpatel]

Hi @Tmanuela,

In your configuration of the datetime parse tool you have selected the wrong date input format, you selected 'dd/MM/yyy', when what you should have selected is 'yyyy-MM-dd'

try and see if that works...hopefully you have fixed it by now.

-prpatel.