Jan 18, 2023 01:33 PM
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
Jan 18, 2023 08:02 PM
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.
Jan 19, 2023 11:47 AM
Thank you this did exactly what I needed