How to set remind message to a user 7 days before his birthday every year?

I need to send remind message to a user 7 days before his birthday every year, how to set the conditions?​


Solution:

Please set the conditions as following:​

(Day(AddDays([Today], 7)) == Day(GetDate([Start Time]))) && (Month(AddDays([Today], 7)) == Month(GetDate([Start Time])))

Applies for: SharePoint 2013, SharePoint 2010, SharePoint 2007

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>