Skip to main content
Question

how to implement is null with date without then condition?

  • June 27, 2018
  • 0 replies
  • 43 views
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
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • June 28, 2018
    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
    Terms & ConditionsAccessibility statement