Help

Re: Birthdays on Airtable

950 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniella_Castel
5 - Automation Enthusiast
5 - Automation Enthusiast

Does anyone else keep tracks of birthday on Airtable? How do you filter it so you can see them in the new year? I typically filter them out by months but just realized that everyone that filled it in last year will now show up this year.

 

TIA!

3 Replies 3

Hm, I'm not sure I follow, sorry!

Let's say my birthday's 22 Jan 1980 and I've entered that into Airtable

What would you like to see in Airtable?

Appreciate your response! Id like to see only Jan 22 since I need to filter this monthly

Ah okay.  What if you used a formula field to check whether the month value of the birthday matched the month value of today like so? 

MONTH(Birthday) = MONTH(TODAY())

Screenshot 2023-01-24 at 12.51.32 PM.png

Then you could filter off of that field

Link to base