Sharepoint 2010 Workflow Triggering emails ahead of date

Question

I want to create a workflow that will look at a date in a column and then send an email 60 or 90 days before that date is current. What would a workflow look like to do that?

Would it be easier to use some other method to set the date to 60 or 90 days ahead in another column? How does Sharepoint prioritize dates? Will I have to make different workflows for each list item or will it be able to scan all dates and say "Here is one that is current, now I'll trigger this email."?

Thanks

Answer 1

Your workflow would look something like this and below DueDate is the column in your list. Based on the DueDate - 60 Days you will set the date workflow variable and workflow would send email only when date variable is met :

Add -60 days to Current Item:Due Date (Output to Variable: date)

then Pause until Variable: date