Discussions

Expand all | Collapse all

Need Date Field to be Blank if Other Field is Blank

  • 1.  Need Date Field to be Blank if Other Field is Blank

     
    Posted 05-08-2017 22:43
    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!


  • 2.  RE: Need Date Field to be Blank if Other Field is Blank

    Posted 05-08-2017 22:46
    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.


  • 3.  RE: Need Date Field to be Blank if Other Field is Blank

     
    Posted 05-08-2017 22:50
    Very logical!! Thank you!