Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Filter by Last Calendar Month

cancel
Showing results for 
Search instead for 
Did you mean: 
Ringthebells86
6 - Interface Innovator
6 - Interface Innovator
Status: New Ideas

Airtable finally added this calendar month as a date filter option which is great, however there needs to be a last calendar month instead of just last month. We need to submit every month our expenses from the previous month. So for example today, I need to be able to see all expenses from January (i.e. last calendar month). How it is now if I do last month, it will show me expenses from Jan 14 - Feb 14 which is not useful.

5 Comments
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeah, I agree that this would be super useful.  I always end up having to create an extra formula field with MONTH(value) and filtering off of that instead

Screenshot 2024-02-15 at 10.52.11 AM.png

YourBlogWorks
4 - Data Explorer
4 - Data Explorer

Definitely needed! Hope it happens soon.

Bastien_Vairet
5 - Automation Enthusiast
5 - Automation Enthusiast

Please, basic need.

Heidi-Qun
4 - Data Explorer
4 - Data Explorer

and please airtable, quit using 'month' in previous, this, next when you really mean 30 days (there are already #days options) - calendar months and quarters are essential for any basic bookkeeping

jarper
4 - Data Explorer
4 - Data Explorer

+1, that is really confusing that we got "this calendar week/month" option, but past/next week/month means really "x day from/before today".
Filtering by calendar weeks, months, quarters and years is must have for any reporting!