Just a thought. If you want the Automation to run more often than once a day in the middle of the night, you can make a new automation to do the same ting and trigger it off some other record being edited that you know if happening regularly during the day by regular users of ideally, triggering off a change into values that cause the formula to be changes, aside from the simple passage of time.
It is very light weight Automation to run a saved table to table import to look for records where the formula is not matching the [last recorded formula date].
So you can set that to be triggered perhaps many times in the day even if mostly it does not change any records, but then at least sometimes it does, thus creating the Work Order(s) earlier than "tomorrow".
