Birthday delivery on the same day | Community
Skip to main content
M
MariBa
Level 2
January 1, 2025
Solved

Birthday delivery on the same day

  • January 1, 2025
  • 1 reply
  • 528 views

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.
Best answer by ParthaSarathy

Hi @mariba ,

Query as,

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

AND

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

 

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
January 1, 2025

Hi @mariba ,

Query as,

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

AND

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

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    M
    MariBaAuthor
    Level 2
    January 1, 2025

    Great, thanks!

    Terms & ConditionsAccessibility statement

    Loading footer...