Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Viewing End Date By Month & Year in a View

1374 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Admin_Departme1
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
Micki_O_Neil
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