Birthday Automations Reset Every Year?

[kierstingeary]

Hi! I am trying to set reminders through the Slack automation when my clients have birthdays. (The day before one of my client's birthday, I get a Slack reminder to send them a gift card). However, because year has to be included in the date, I am not getting the automation to work (for example, my client's birthday was Aug 3, 1990. I can always change the year to 2023 so that the automation works, but then I would have to change it to 2024 for it to work for the following year.) I do not to see a way to omit year in this automation.  No luck from the Airtable support team. Does anyone have any ideas?

[Sho]

Hi @kierstingeary,

Add a Formula field and enter a formula like this

DATETIME_PARSE(YEAR(TODAY())&"-"&DATETIME_FORMAT({birthday},"M-D"))

This formula always displays the date of this year's birthday.

[kierstingeary]

@Sho Thanks so much! And this will automatically update each year? 

[Sho]

Yes, it will always be the birthday of the current year.
In the case of a leap year on February 29, it will be March 1.

[kierstingeary]

Thank you! This is working perfectly, although I'm seeing one issue:

For some October dates, the formula is defaulting to 10/1. See the attached here. Any ideas?

[Sho]

It seems that parsing the date from the string is failing; I think specifying a PARSE format will solve this problem.

DATETIME_PARSE(YEAR(TODAY())&"-"&DATETIME_FORMAT(Date,"M-D"),"YYYY-M-D")