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? |
Birthday Automations Reset Every Year?
+3
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.
+3Sho wrote:
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.
@Sho Thanks so much! And this will automatically update each year?
kierstingeary wrote:
@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.
+3Sho wrote:
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.
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?
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")Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.