Target Birthday Email | Community
Skip to main content
S
SaurabhJoshi
August 4, 2022
Solved

Target Birthday Email

  • August 4, 2022
  • 2 replies
  • 1066 views

Hi,

 

I want to target recipients who DOB is like today date but, I want to send him email 5 days before.. on his current birthday date..

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 @saurabhjoshi ,

Try Below Query,

Day(@birthDate) EQUAL TO Day(AddDays( GetDate() , 5))

AND

Month(@birthDate) EQUAL TO Month(AddDays( GetDate() , 5))

 

So, When the workflow runs today (4th August), Recipients who has birthday on 9th August will be targeted today (4th August).

 

Regards,

ParthaSarathy

2 replies

I
Adobe Employee
imicuAdobe Employee
Adobe Employee
August 4, 2022

Hi,

 

You could send the email today and date of birth is today plus 5 days. Will this work for your case?

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
August 4, 2022

Hi @saurabhjoshi ,

Try Below Query,

Day(@birthDate) EQUAL TO Day(AddDays( GetDate() , 5))

AND

Month(@birthDate) EQUAL TO Month(AddDays( GetDate() , 5))

 

So, When the workflow runs today (4th August), Recipients who has birthday on 9th August will be targeted today (4th August).

 

Regards,

ParthaSarathy

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    David_Loyd
    Adobe Employee
    David_LoydAdobe Employee
    Adobe Employee
    August 5, 2022

    Don't forget to schedule this workflow to run daily.

      Terms & ConditionsAccessibility statement

      Loading footer...