Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 11, 2016 07:00 AM
I cannot figure out how to filter all entries where “date” is the current month.
Solved! Go to Solution.
Dec 13, 2020 04:46 AM
Worked like a charm, thanks!
Jul 30, 2021 05:59 PM
With all the advancements Airtable have been making, this work-around process to filter by the current week, month and year is starting to get old. Can AT please, please please add “This Week, This Month and This Year” filters as options?
Almost all of my tables that utilize date columns are then typically burdened with these extra columns to drive the table views that are so very critical within my automations.
Oct 06, 2021 12:04 PM
There is no sense to creating formulas just because AT doesn’t have a filter like this month, year, week…
It’s totally unacceptable.
Oct 06, 2021 01:29 PM
Yah, it’s frustrating, but this method I’ve captured below will at least work so that you can do what you need to do.
(DATETIME_FORMAT({Test_Date_Time}, 'MM') - DATETIME_FORMAT(TODAY(), 'MM')) +((DATETIME_FORMAT({Test_Date_Time}, 'YYYY') - DATETIME_FORMAT(TODAY(), 'YYYY')) * 12)
It’s worth reaching out to Airtable Support with this feature enhancement request, considering they’re actively working on the filters (which is epic!) and released new and/or group search features this morning.
Mar 16, 2023 03:52 AM
Hi support team!
How are you? Can you check this?
Actually, I try to expression these conditions in php, but I don't understand and not clear how to convert these conditions in php.