Convert a date from yyyy-mm-dd to mm/dd/yyyy format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Bitopi,
You'll want to use the DateTime tool - as shown below - Please view the attached workflow:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much. It worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Agreed, the format changed as expected. But how to retain the data type? Requesting to change only the format, not the data type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @atcodedog05 , sure, I'll post a new query 🙂 thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
