Date is not Blank - Not working correctly?

Hello everyone,

I am having an issue with a pretty simple if statement with !=blank():
If({Date}=blank(), “Blank”, “Not blank”) - this returns “Blank” if the field is blank and “Not blank” if there is something is entered - as it should
If({Date}!=blank(), “Blank”, “Not blank”) - this returns “Blank” no matter if the field is empty or not

Am I missing something?

Thanks,
Jordan

BLANK() is used for other purposes. Just compare your Date field to "":

{Date}=""

1 Like

Just use your date field by itself in the IF function.

IF(
  {Date},
  "There is a date",
  "No date"
)

This works for all editable field types except for number fields that could be zero.

2 Likes

Thank you both, I had implemented a work around but those are both much simpler!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.