Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date is not Blank - Not working correctly?

Topic Labels: Dates & Timezones
Solved
Jump to Solution
247 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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

{Date}=""

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.

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