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."?