My date formats are inconsistent and I am trying to align them in one 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
There are two date columns "close date-original" and "tax date-original" which has inconsistent date formats and i am trying to re-align them to mm/dd/yyyy format. I was able to convert the close date correctly into this format but for certain tax dates the output is rendering a different date when I am trying to use the same formula. For eg. 12/1/2016 as 1/20/2012. Attaching workflow for reference. Kindly advise me. Thanks a lot!
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @B_bhatta
Honestly it makes no sense why its not working 😶 was not able to find the issue too.
I have tweaked the workflow little bit (if statement order) now it seems to work.
Output:
Please check and let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @B_bhatta , the if else statement for Tax Date had to be ordered first you need to parse mm/dd/yyyy after that yyyy-mm-dd.
I hope this helps, kindly mark this post as solution.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 this worked. Thanks a lot 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jean-Balteryx - The solution worked for me. Thank you 😃
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
