I’ve worked around this with a View, and the trigger is when the record enters the View.
You have a few ways you could configure your view: The view can be based on “Last Modified Time” as yesterday. Or, if your modifying more to a record than just the status, you could add a layered filter of a checkbox or date field. It’s not the best, but it works!