Add is empty/not empty to Date fields

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.

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