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

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

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

Level 5

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