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

    When Date field is Null


      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.