Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Target Birthday Email

Avatar

Level 1

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..

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hi @SaurabhJoshi ,

Try Below Query,

Birthday.PNG

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

View solution in original post

4 Replies

Avatar

Employee

Hi,

 

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

Avatar

Correct answer by
Level 7

Hi @SaurabhJoshi ,

Try Below Query,

Birthday.PNG

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

Avatar

Level 1

Hi,

another solution would be to use the "DayOfYear" function.

 

DayOfYear(@birthDateEQUAL TO DayOfYear(AddDays( GetDate() , 5))

 

Regards,

Aurélien