how to implement is null with date without then condition?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
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
Photo of Pushpakumar Gnanadurai

Posted 6 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,286 Points 5k badge 2x thumb
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. 
Hi Evan,

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

Thanks