I must create a couple of Workflows, which will send notification to users (something like a reminder).
I have created a first WF that will be activated when item will be created or modified (SharePoint Online 2013).
WF-1 If State = New or Offer send and Email has not been sent then, pause until DeadlineDay = Today --> send email and change state to EmailHasBeenSent.
It's working fine, but if user will change the Deadline date The new WF will be created (maybe) and previously WF are still working. I don't know how to stop this WF.
Example: Deadline = 25.09.2013 WF will set this date to send email. If I change date to Deadline = 30.09.2013 Email will be sent on 25.09.2013.
How can I do WF that will be check every day is the date has been change?
and
How to send mail every quarter till expiry date using sharepoint designer workflow
Second WF if similar but sends an email two days before the Deadline -> 2DaysBeforeDeadline.
Can you help me design this WF (step-by-step)?