Thank you, @adamhholmes. The idea to run a workflow to update the date at midnight sounds like a simple solution. Any ideas on how might that workflow might look?
Thank you so much.