I am currently in a situation where we have recurring events (Birthday reminders) that send out an email to facilities to buy birthday card.
The email (sent 3 days before) reads like this: Please buy card for person XY since birthday is coming on (current date, not the first instance of the recurring serie).
If I see in my Sharepoint how the system handles the recurring item it shows as start date 2013 (or 14 or 15, according to when it was entered) and as end date 2164.
When in the email I enter the field for the date, if I use the Startdate I get the first instance of the series (ie 2013), if I use enddate, I get 2164.
Is there a way to establish within the workflow or using an extra calculated column in the calendar to tell him to write the current date/year? Is it the best way to approach the problem?
The only workaround I found is to delete past entries of the series so that the workflow restarts and the start date is always the one in next year (which is a tedious job)