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..
Solved! Go to Solution.
Views
Replies
Total Likes
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
Hi,
You could send the email today and date of birth is today plus 5 days. Will this work for your case?
Views
Replies
Total Likes
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
Don't forget to schedule this workflow to run daily.
Hi,
another solution would be to use the "DayOfYear" function.
DayOfYear(@birthDate) EQUAL TO DayOfYear(AddDays( GetDate() , 5))
Regards,
Aurélien
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies