This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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.
{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}.
FALSE()
0
{Date Field}
TRUE()
1
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.
{Is Dated?} = 1
{Is Dated?} = 0
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?
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
Welcome Brett, please mark it as solved
never-displayed