Target Birthday Email

[SaurabhJoshi]

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

[imicu]

Hi,

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

[ParthaSarathy · Accepted solution]

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

[David_Loyd]

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

[aurélient771702]

Hi,

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

DayOfYear(@birthDate) EQUAL TO DayOfYear(AddDays( GetDate() , 5))

Regards,

Aurélien