Change specific date to a blank cell

[mickala21]

Hi All, I'm new to Alteryx and hoping I have a simple question for you.  I have a database that fills in blank fields with the date 1/1/1900.  How would I convert this date to a blank cell? I'm creating an error report that is looking for blanks, but I need to include this date as a blank.

[afv2688 · Accepted solution]

Hi @mickala21 

Are they string fields or date fields on alteryx? If they are date fields you will need to use this:

IF [Field1]="1/1/1900" THEN Null() ELSE [Field1] ENDIF

If they are string you can choose between these 2:

IF [Field1]="1/1/1900" THEN Null() ELSE [Field1] ENDIF

IF [Field1]="1/1/1900" THEN "" ELSE [Field1] ENDIF       (blank instead of null)

cheers

[mickala21]

Perfect! To get this to work, I had to use the same format that the field was in 1900-01-01 00:00:00 

After that I got it to work!