Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Viewing End Date By Month & Year in a View

68 2
Showing results for 
Search instead for 
Did you mean: 

Hey Airtable Community, 

Not sure if this is the right place to put this question, and if it isnt let me know.   

We currently have 150 clients in our Airtable base, all with end dates for when the service ends.  I currently have a view for 30 days before a clients end date, it will populate in that view and notify their team.

Does anyone know if its possible for me to have a view that would be based on Month and Year?  ie, anyone with a end date in January 2023 would populate in that view?

Thanks in advance

2 Replies 2

Yes, but you have to add a field for month and a field for year. Then use the Month() and Year() formulas and filter on those fields.

Thank you this did exactly what I needed