Help

Filter between a start and an end date on an interface

Topic Labels: Interface Designer
1018 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ParisiamAT
4 - Data Explorer
4 - Data Explorer

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?

 

 

 

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

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

Thanks for your reply and for the workaround !

I've just written to the support as you suggested.

Awesome!