So some background:

We have a module where we store info on loans borrowed. This module has a field called "Days until debt is due", and this field works by calculating the difference between the current day (indicated by the "Now()" method), and the date the debt is due.

However, I realized that for records in the CRM, any field involving the use of "Now()" is not dynamically updated so it reflects the current day. "Now()" only updates when the module is updated. 

After some googling, I got around this somewhat by making a dummy checkbox called "Mass Update". I use the Mass Update function to turn this box on, and that updates all the records so the value in the field changes. 

My dilemma is this - I can still use this field for the purposes that I need it for, but it still requires me to manually perform the mass update every day so the value actually changes. I'm wondering if there's some way to automate this process of mass updating the dummy checkbox, so I don't have to do it every single day on my own!