Expand my Community achievements bar.

The 5th 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
Community Advisor

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

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
Community Advisor

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

Employee Advisor

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

Avatar

Level 1

Hi,

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

 

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

 

Regards,

Aurélien

page footer