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
Best answer by kuovonne
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.
+35BLANK() is used for other purposes. Just compare your Date field to "":
{Date}=""
+29Just 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.