Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automations for Birthday Notifications in Outlook Airtable

821 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alvaro_Sanchez
4 - Data Explorer
4 - Data Explorer

Hello!,

I want to create an automation to send an email from outlook using Airtable. I have everything, and for trigger, I want to use the date of birth, but in the current year. I use a formula that I’ve found in another topic that is

DATEADD(
Birthday,
DATETIME_DIFF(TODAY(), Birthday, ‘years’),‘years’
)

But I have one problem. A lot of dates, when the formula runs, instead of 2022, put 2021, and I don’t know why. Anyone could help me? I don’t know if it is a format problem or what

Thank you

0 Replies 0