Skip to main content

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