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.
Solved! Go to Solution.
Hi @Bitopi,
You'll want to use the DateTime tool - as shown below - Please view the attached workflow:
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.
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
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 🙂
hi @atcodedog05 , sure, I'll post a new query 🙂 thanks
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.