I’d like to be able to filter for date fields when it is/is not empty.
That option doesn’t currently exist in my filter drop-downs.
You could probably work around this pretty easily with a formula field that checks this for you.
Formula Field: {Is Dated?}
IF({Date Field}, TRUE())
This will return FALSE()
, or 0
when the {Date Field}
is empty, and TRUE()
or 1
, when there is any value at all in the {Date Field}
.
Now you can filter records where {Is Dated?} = 1
to get records WITH dates filled in, or {Is Dated?} = 0
to get record where the date field is blank.
Thanks Jeremy, but I figured that given that this simple filter selection exists with most other field types, I can’t see a reason why it couldn’t exist here too.
Thanks Jeremy, but I figured that given that this simple filter selection exists with most other field types, I can’t see a reason why it couldn’t exist here too.
Hi @Brett_D,
The option is there. Please see below screenshot.
OK, now I’m confused. Because for me it’s not there. To clarify, you are using the date field?
OK, now I’m confused. Because for me it’s not there. To clarify, you are using the date field?
Hi Brett,
Yes I am using the date field. The problem is you are looking for it in the “Exact Date” drop list. You should look for it in the “is” drop list
Hi Brett,
Yes I am using the date field. The problem is you are looking for it in the “Exact Date” drop list. You should look for it in the “is” drop list
Oh good. I knew Airtable was smarter than me! Thanks so much for helping me here Mohamed
Oh good. I knew Airtable was smarter than me! Thanks so much for helping me here Mohamed
Welcome Brett, please mark it as solved
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.