Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 11, 2023 08:36 AM
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? |
Sep 11, 2023 06:24 PM
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.
Sep 11, 2023 08:37 PM
@Sho Thanks so much! And this will automatically update each year?
Sep 11, 2023 09:01 PM
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.
Sep 13, 2023 10:51 AM
Sep 13, 2023 04:38 PM
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")