Macro for Status Change

The workflow we follow is that for tickets that have a task that is scheduled in the future, we will set the due date accordingly and set the status to "service scheduled". The problem with this is the status does not change, even if we go past the due date. I was curious if there was a way to have the status flip back to "open" the morning the due date is set for. Any help you can provide would be greatly appreciated.