Airtable – Current Month Filter

Here’s a way to create a filter so it automatically switches each month:

Create a formula field in the table called “Is current month”. We want this formula to be 1 when the date is in the current month, and 0 otherwise. So we can use this formula:

DATETIME_FORMAT({Name of your date field}, ‘YYYY-MM’) = DATETIME_FORMAT(NOW(), ‘YYYY-MM’)

Now you can create a filter where “Is current month” is equal to 1.

Here’s a base that shows this set up: https://airtable.com/shr1WzfJyhsdV5HlV/tblY9aNHNVFjtgP1v/viwau4UAl4y9H0DWl16

Leave a Reply