How filter certain date and replace it with blank on row/cell

[BILearnerToday]

Hi Everyone,

Kindly advise, I have a date column that brings one default date which is (02/12/1940 with blank) and I want to replace it with a blank column for example.

Date                           New Date Column

02/12/1940         

04/12/1990                 04/12/1990 

Basically, the new date column is now blank on the row in which we have the default date which needs replacing with blank. 

[Samarth_18 · Accepted solution]

Hi @BILearnerToday ,

You could try to create a column as below:-

Column = IF([Date] = DATE(1940,02,12),BLANK(),[Date])

Output:-

Thanks,

Samarth