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.
