More filter date options desperately needed

[Ringthebells86]

What is the proposed idea/solution?

Airtable desperately needs more options for date filtering. Most importantly the following:

• within next calendar week/month
• within past calendar week/month
• on or before the end of this calendar week
• on or before the end of next calendar week

Airtable barely has filters for calendar weeks which is extremely frustrating because most program managers are looking at the tasks for the given week and it is super annoying to have to make it a custom between 2 date fields because saying on or before one week from now will show tasks from the following week within the first few days.

How does is solve the user problems?

This makes searches more automated so they will automatically show you what is happening in the given calendar week/month without having to do the current way which is:

Date is on or after 11/1/2024 or date is on or before 11/30/2024 (which has to manually be changed every month). It just makes things unnecessarily difficult when it should just be simple to add these date filters. 

[DisraeliGears01]

Potential workaround for you for the moment at least, add a formula field with Datetimeformat({datefield}, 'MMMM) which will output the month, and then turn that into a single select output. Then you can add a filter with "Month=November + Date=This year". Perhaps that helps?

[Alexey_Gusev]

Hi,
My opinion:
On the one hand, I agree that each user has their own needs. And everything that is missing can be expressed in a formula.
On the other hand, filters by calendar week and month (possibly quarter and year) are indeed often needed. Perhaps even more often than those filters that count from the current date, which are currently available. However, there is one nuance - when I just started working with Airtable, I got confused even with the date filters that were there at the time, and I had to practice on test tables until I clearly understood how they worked. If more filters are added, it might make sense to make the settings more user-friendly for those who don't have a lot of experience - add some kind of hint that would show the result for the current field. For example, the preview for formulas, recently added, is indeed quite helpful when creating them.