Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Different Date Formats

maier_alexander_MO
8 - Asteroid

Dear all,

 

I have several Excel Input Sheets (roughly 30) from different countries which I am trying to aggregate.

Sadly I have the typical issue of different Date formats - namely three different types:

 

YYYY-MM-DD 

DD.MM-YYYY

DD/MM/YYYY 

 

I have already converted the second and third date format to a new column and do now have three columns which i want to aggregate to one:

 

Date_Okay 

Date_Help_1

Date_Help_2 

 

Each of the columns shows either the correct date or a [Null]

 

clipboard_image_0.png

 

I now want to aggregate the three columns to one and thus elminating the [Null] values. I used the following formula which is not working:

 

IF [Date_Help1]!="Null" THEN [Date_Help1] ELSEIF [Date_Help2]!="Null" THEN [Date_Help2] ELSE [Date_Okay] ENDIF

 

Do you have an idea on how to solve this?

 

Thank you very much in advance!

Best regards, Alex

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @maier_alexander_MO try using this syntax . You want to use the test functions within the formula tool you can use a ! to test is not as well.

 

IF !IsNull([Date_Help1])THEN [Date_Help1]
ELSEIF !IsNull([Date_Help2])THEN [Date_Help2]
ELSE [Date_Okay] ENDIF

 

Test_Functions_190919.PNG

 

 

maier_alexander_MO
8 - Asteroid

Hi JS420, 

 

thank you very much for your quick help on the below, that solved my problem! 

 

Have a nice day and kind regards,

 

Alex

Labels