Re: Viewing End Date By Month & Year in a View

900 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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
7 - App Architect
7 - App Architect

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