Forum Discussion

BILearnerToday's avatar
BILearnerToday
Frequent Visitor
4 years ago
Solved

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

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. 

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi BILearnerToday ,

     

    You could try to create a column as below:-

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

    Output:-

     

    Thanks,

    Samarth

     

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi BILearnerToday ,

     

    You could try to create a column as below:-

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

    Output:-

     

    Thanks,

    Samarth