topic Different Date Formats in Alteryx Designer Desktop Discussions

Different Date Formats

maier_alexander_MO — Thu, 19 Sep 2019 12:06:22 GMT

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]

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

JosephSerpis — Thu, 19 Sep 2019 12:12:52 GMT

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

maier_alexander_MO — Thu, 19 Sep 2019 12:58:13 GMT

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