I need a workflow to track a due date on an list and 5 days before due date send a reminder email till the due date like need daily one reminder till the due date.
I have created a calculated column in the list Modified +180=Due date
And also I have one more column with Yes and No for the first time it will Yes
5 days before due date the column should change to No .
Once the Column after the due day is modified column changes to Yes.
and again the mail to trigger workflow after 6 months (modified+180)go on.
Can you please help me how to achieve this
Did you figure this out? I want to do the same thing