Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
7 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,...
Formulas and functions
EvanMartinez's avatar
EvanMartinez
Moderator
7 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.