Date is not Blank - Not working correctly?

[Jordan_M]

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

[ScottWorld]

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

{Date}=""

[kuovonne · Accepted solution]

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.

[Jordan_M]

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