In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

B_bhatta
7 - Meteor

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!

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

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:

atcodedog05_0-1604479676140.png

 

Please check and let me know.

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @B_bhatta ,

 

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

 

Cheers,

 

Jean-Baptiste

grazitti_sapna
17 - Castor

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.

 

grazitti_sapna_0-1604480425604.png

 

I hope this helps, kindly mark this post as solution.

Thanks.

 

Sapna Gupta
B_bhatta
7 - Meteor

@atcodedog05  this worked. Thanks a lot 🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @B_bhatta 

 

Cheers and Happy Analyzing 😀

B_bhatta
7 - Meteor

@Jean-Balteryx - The solution worked for me. Thank you ðŸ˜ƒ

Jean-Balteryx
16 - Nebula
16 - Nebula

My pleasure @B_bhatta ! 🙂

 

Cheers,

 

Jean-Baptiste

Labels
Top Solution Authors