Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
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

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

Hi,

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

 

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

 

Regards,

Aurélien