Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
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!
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?
Jan 23, 2023 10:00 AM
Appreciate your response! Id like to see only Jan 22 since I need to filter this monthly
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())
Then you could filter off of that field