Skip to main content
Question

Need Date Field to be Blank if Other Field is Blank

  • May 9, 2017
  • 0 replies
  • 47 views

Forum|alt.badge.img+6
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 no value in the [Next Reminder # Days before Exp] field...instead if is display the date in the [Expires] field.

How can I have this date field be blank if [Next Reminder # Days before Exp] is also blank?

Thank you!
This topic has been closed for replies.

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.

Forum|alt.badge.img+6
  • Author
  • Quickbase Alumni
  • May 9, 2017
Very logical!! Thank you!