1 Reply Latest reply on Apr 17, 2015 2:54 PM by Shawn Wallwork

    When Date field is Null

    ELLE RISTOW

      Hello everyone,

       

      I want to create a calculated field based on Date field that has null values.

       

      If this date field is null, I want to call it "A"

      If this date field is not null, I want it to be presented as itself.

       

      I tried to use IF statement with ISNULL but found out that it has to be String. So I used STR to convert this date to String then I end up with string value of this date when it is not null. Is there any solution for this?

       

      Thanks so much for your time.