Forum Discussion

AmberPollard's avatar
AmberPollard
Qrew Assistant Captain
9 years ago

Need Date Field to be Blank if Other Field is Blank

My [Next Reminder Date] formula is: If(not IsNull([Next Reminder # Days before Exp]), [Expires]-Days([Next Reminder # Days before Exp]), null),  but this field is not appearing blank if there is n...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
No problem,

Examine the field properties for the field [Next Reminder # Days before Exp] and uncheck the box which says to treat blank as zero.  That will make a blank treated as a null.