Mar 27, 2024 03:35 AM
I've created a dashboard interface and I've added a filter by date.
I can do many type of filtering such as "is after...", "is before..." but I cannot filter between 2 specific dates.
It seems that a "Is between (exact dates)" filter is missing.
There's a "Is within" filter that seems close, BUT it does not allow to select specific dates.
Is there a solution to that problem or am I missing something?
Mar 27, 2024 05:16 AM - edited Mar 27, 2024 05:17 AM
Unfortunately, you are not missing anything.
Strangely & tragically, Airtable has removed this option from all the new interface pages.
Please be sure to email support@airtable.com to ask them to give us this feature back again.
Although, even in the past, it wasn’t super user-friendly.
In the past, you had to choose one date and specify “on or before”, and then you had to choose another date and specify “on or after”.
The workaround for this now is to create a formula field that equals the original date field, and then create 2 filters… one based on each date field.
What Airtable really needs to do is simply give us a “date range” option, where we can specify the start date and the end date.
Be sure to email support@airtable.com with this feature request.
- Scott Rose, Expert Airtable Consultant at ScottWorld
Mar 27, 2024 05:24 AM
Thanks for your reply and for the workaround !
I've just written to the support as you suggested.
Mar 27, 2024 05:26 AM
Awesome!