SOLVED
How can i convert different date format in one consistent date format?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
B_bhatta
7 - Meteor
11-03-2020
07:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My file has two date formats i.e. dd-mm-yyyy & mm/dd/yyyy hours:mins:secs. Can you please advise how can i convert these dates into an mm/dd/yyyy format. Attaching the current file for reference.
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
5 REPLIES 5
JosephSerpis
17 - Castor
11-03-2020
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @B_bhatta I mocked up a workflow let me know what you think?
atcodedog05
22 - Nova
11-03-2020
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @B_bhatta
Here is a workflow for the task.
Output:
Workflow:
Add new format here:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
11-03-2020
08:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot @JosephSerpis for the workflow. It worked
11-03-2020
08:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05,
This solution also worked me. Thanks 😀
atcodedog05
22 - Nova
11-03-2020
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator