Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

how to implement is null with date without then condition?

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
Formulas and functions

2 Replies

Sort By
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    6 years ago
    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. 
  • PushpakumarGna1's avatar
    PushpakumarGna1
    Qrew Assistant Captain
    6 years ago
    Hi Evan,

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

    Thanks