Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Birthdays on Airtable

1705 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Daniella_Castel
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎Jan 18, 2023 04:35 PM

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!

0 Kudos
Reply
3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto
See Solution in Thread

‎Jan 21, 2023 05:01 PM

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?


0 Kudos
Reply
Daniella_Castel
5 - Automation Enthusiast
5 - Automation Enthusiast
In response to TheTimeSavingCo
See Solution in Thread

‎Jan 23, 2023 10:00 AM

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

0 Kudos
Reply
TheTimeSavingCo
18 - Pluto
18 - Pluto
In response to Daniella_Castel
See Solution in Thread

‎Jan 23, 2023 08:57 PM

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


0 Kudos
Reply
Copyright © 2025 Khoros, LLC