Skip to main content
Level 2
Jan 1, 2025 8:31 AM UTC
Solved

Birthday delivery on the same day

Hi,

 

I want to send our club members an email on their birthday.
How do I set up the formula so it would disregard the year and would only check the the day and month of the birthdate?

 

Thanks
Marie

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Jan 1, 2025 8:39 AM UTC

Hi @mariba ,

Query as,

Day(@birthDate) equal to Day(GetDate())

AND

Month(@birthDate) equal to Month(GetDate())

 

~  ParthaSarathy S

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Jan 1, 2025 8:39 AM UTC

Hi @mariba ,

Query as,

Day(@birthDate) equal to Day(GetDate())

AND

Month(@birthDate) equal to Month(GetDate())

 

Translate
~  ParthaSarathy S
MariBaAuthor
Level 2
Jan 1, 2025 10:39 AM UTC

Great, thanks!

Translate