Pending State to Active when Due Date hits

[krism]

In short what I am looking for are the following items:

1. I would like to have all Incidents that are in a Pending State and have a "due date" automatically set back to active when the due date hits
2. I would like to have all Incidents that are in a Pending State and do NOT have a "due date" to be set back to active every night at midnight

Anyone have any ideas? I have a short and sweet work flow that will work for the 1st one. Basically it has a Timer that says when due date is "Full Duration" Change state to active. That works well but if you open that ticket that was changed back to active and set it back to pending and set a new "due date", it will not re run that workflow and kick it back into when the due date hits.

[PeterWiles]

I might be just getting confused.

So the workflow is:
Incident table
Conditions - when state = pending and due date is in the future
Flow - wait till due date, set active, end

Is that correct? If you reset the incident back to pending, does a new workflow of the above start or do you reuse the workflow started orginally?

If your reusing the same workflow, I would test with not doing that. Just kick off a new workflow each time you set pending.

If you are creating a new workflow of the above each time, make sure the old workflow is finishing.

On a slight different note, do you cancel the workflow if some one manually changes the state on the incident?