Change specific date to a blank cell

Question

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 Answer

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