Help

Re: Date is not Blank - Not working correctly?

Solved
Jump to Solution
2078 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jordan_M
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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}=""

kuovonne
18 - Pluto
18 - Pluto

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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