how to implement is null with date without then condition? | Discussions

Expand all | Collapse all

how to implement is null with date without then condition?

  • 1.  how to implement is null with date without then condition?

    Posted 06-27-2018 17:41
    Hi , Can some one help me to implement IF and is null condition without then?

    Eg: IF approval_dt IS Null THEN Implement_Dt = X_Dt + 30

    then there is no else condition.

    We have only Nz(date x,date y) but not Nz(date)

    Thanks


  • 2.  RE: how to implement is null with date without then condition?

    Top
    Contributor
    Posted 06-28-2018 14:43
    Hi Pushpakumar,

    If you are looking for the right function to evaluate if a date field is null (blank) I most often make use of:

    IsNull([Date]) 

    This will return whether a date field is blank or has been given a value and can be plugged into longer formulas for that evaluation. I hope this information is helpful. 


  • 3.  RE: how to implement is null with date without then condition?

    Posted 06-28-2018 20:06
    Hi Evan,

    Thanks a lot. That worked. I was unaware of the function IsNull . Just trying my luck with Nz

    Thanks