How to create a new record daily if date is within parameters

I have a Lease Terms table that has a child table called Months and the Months table has a child table called Days. The Months table  records (one per month) are added simultaneously when a user checks a box in the Lease Terms table after filling in the necessary data.

I have fields that determine the number of days in each month in the Months table. What I need to do is add a Day record every day (daily, not simultaneously) for leases that are currently in effect so that I can snapshot the base rent amount, leasable area, etc. on the specific date because these numbers change throughout the lease (for instance, if new mall tenants come aboard mid-month then the shared expenses (CAM) are divided among the new number of tenants starting on the day the new tenants take possession, so that CAM charges may be calculated at one rate from the beginning of the year, but a different rate as new tenants are added).

However, scheduling an automation won't work because there are no options to filter or create Day records for only leases that are actually in effect, and an automation that relies upon changing data won't work because no user is changing data - just the date (Today()) changes in formulas.

I feel like I'm missing something obvious but I've spent the better part of the day trying to figure it out and I've hit a wall. Any help would be very much appreciated :-) 

Thanks,

AJ

------------------------------
Albert Campani
Partner
Richards, Higdon, Huguet & Campani, APLC
Covington LA
------------------------------