"On Hold / Waiting" status to be changed to "Investigating" when today's date is the same as "Due Date"
Some of our users enter in a "Due Date" when submitting a ticket, this can be several months ahead of the ticket needing actioning.
The helpdesk engineers will then place that ticket on hold until the due date is reached.
Would it be possible to have a rule that if a due date is set and the status is on hold, then when that day comes it will put the ticket in an investigating status?
This will then email the engineer that this ticket need to be looked at today.