How do I target customers who celebrate their birthday this week? | Community
Skip to main content
M
MariBa
Level 2
March 2, 2025
Solved

How do I target customers who celebrate their birthday this week?

  • March 2, 2025
  • 1 reply
  • 1104 views

Hi,

I need to send an email to customers who celebrate their birthday this week.

I see I can create an expression based on the Month of the date of birth, and based on the day of date of birth.

Is there an option to only get those who celebrate their birthday this week? I could find a date expression I could use for that purpose.

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

I tried the new condition but I'm getting an error.
I'm attaching print screens from the query. I can't seem to find what I'm doing wrong. maybe it has something to do with the account permissions? I'm not an admin.

 

 

 

 


@mariba , Say you're running the campaign on Day-1 of the every week and need to target those who have birthday on this week, you can try below condition,

Day(@birthDate) on or after Day( GetDate())

AND

Day(@birthDate) on or before Day(AddDays( GetDate() , 7))

AND
Month(@birthDate) on or after Month( GetDate())

AND

Month(@birthDate) on or before Month(AddDays( GetDate() , 7))

 

As a result, you can get all the recipients who has birthday this week:

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
March 2, 2025

Hi @mariba ,

You can try the Query as,

ToInteger((DaysDiff(@birthDate, ToDateTime('01/01/'+Year(@birthDate))))/7)

Equals to

ToInteger((DaysDiff(GetDate(), ToDateTime('01/01/'+Year(GetDate()))))/7)

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

    Thanks for the quick reply.

    I tried it but the term "on or after" / "on or before" gets changed to "equal or greater than" / "equal or less than".

    the outcome is all the customers whose birthday is today only. 

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    March 2, 2025

    @mariba , try the condition updated above. This calculates and compares the week of birth date in recipient's birth year and week of current week.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...