I have defined the above workflow in Sharepoint 2007
Late Date is set by the workflow to be 1 day later than the due date (currently it is set to 5 minutes for testing purposes). It is the field that is used to trigger when the late notification is sent out.
Date Counter is a field that is updated by the workflow to monitor the passage of time. On initial creation Date Counter is set to Create Date. On modification, Date Counter is set to modified date. The workflow compares Date Counter to the Due Date. If it Date Counter is less than Due Date, the workflow then sets it to the Due Date and pauses until due date. If the Date Counter is equal to the due date and status is not complete, it sends an email indicating the task is due. If the due date counter is greater than or equal to the late date and the task isn’t complete, it sends a notice the task is late.
When run, I get the first e-mail when due date is reached and also the second e-mail when late date is reached. But subsequent e-mails which must be sent evry 5 mins is not being sent. (The late date and date counter are incremented by 5 mins. each time). NOT SURE WHY