Target Birthday Email

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

ParthaSarathyAccepted solution

New Participant

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

Employee

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

Employee

Hi,

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

Sign up