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

Birthday delivery on the same day

  • January 1, 2025
  • 1 reply
  • 527 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

Best answer by ParthaSarathy

Hi @mariba ,

Query as,

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

AND

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

 

1 reply

ParthaSarathy
ParthaSarathyAccepted solution
New Participant
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
    New Participant
    January 1, 2025

    Great, thanks!

    Terms & ConditionsAccessibility statement

    Loading footer...