Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Birthday Automations Reset Every Year?

1282 0
cancel
Showing results for 
Search instead for 
Did you mean: 
kierstingeary
5 - Automation Enthusiast
5 - Automation Enthusiast
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? 
 
5 Replies 5
Sho
11 - Venus
11 - Venus

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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
11 - Venus
11 - Venus

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