Expand my Community achievements bar.

SOLVED

Birthday delivery on the same day

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @MariBa ,

Query as,

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

AND

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

ParthaSarathy_0-1735720731390.png

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @MariBa ,

Query as,

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

AND

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

ParthaSarathy_0-1735720731390.png