Birthdays on Airtable

[Daniella_Castel]

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!

[TheTimeSavingCo]

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?

[Daniella_Castel]

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

[TheTimeSavingCo]

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())

Then you could filter off of that field

Link to base