Need Date Field to be Blank if Other Field is Blank

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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!
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
(Edited)
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb
Very logical!! Thank you!