Skip to main content

Birthdays on Airtable

  • January 19, 2023
  • 3 replies
  • 33 views

Forum|alt.badge.img+4

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

TheTimeSavingCo
Forum|alt.badge.img+31

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?


Forum|alt.badge.img+4
  • Author
  • New Participant
  • January 23, 2023

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


TheTimeSavingCo
Forum|alt.badge.img+31

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

Then you could filter off of that field

Link to base