On Hold timers for incident, problem and change records

[mflexman]

I need some help, i have created a couple of fields which allow staff to put incidents, problems and requests on hold and to set a date/time when the on hold expires. I followed this up with a workflow using a timer which then takes the record off hold when the date/time field expires.

However, as Im using a workflow, if the staff member changes the value of the on hold expiry date/time to some further date in the future then the record still comes off hold at the original time.

Seemed like a good idea at the time but I now need to change this so that whenever the date/time field is reached (regardless of how many times it was changed), the record gets taken off hold.

Any ideas please, Im going very quickly insane over this 😞

Thanks
Mark

[NeilH2]

Instead of using a workflow have you thought about using a scheduled job to check the task table for any on hold dates about to expire?

The major benefit of this is it doesn't matter if the date changes as the job is checking current record values.
You can also have the job update the record if the date is reached.

[mflexman]

Perfect - thanks for the inspiration, works a treat 🙂