My date formats are inconsistent and I am trying to align them in one format.

[B_bhatta]

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!

[atcodedog05 · Accepted solution]

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.

[Jean-Balteryx · Accepted solution]

Hi @B_bhatta ,

Here is a workflow doing the job ! I hope it helps you.

Cheers,

Jean-Baptiste

[grazitti_sapna · Accepted solution]

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.

[B_bhatta]

@atcodedog05  this worked. Thanks a lot 🙂

[atcodedog05]

Happy to help 🙂 @B_bhatta 

Cheers and Happy Analyzing 😀

[B_bhatta]

@Jean-Balteryx - The solution worked for me. Thank you 😃

[Jean-Balteryx]

My pleasure @B_bhatta ! 🙂

Cheers,

Jean-Baptiste