automatic Recurring trigger to execute interest calculation

[atrium]

I want to calculate interest on a daily bases for a week, fortnight or monthly period. I have a lot of schedules that need their interest updated. I can write some code to check the frequency and do the calculation for 7, 14 or 30.5 days. But how do I trigger that for a schedule that hasn't been opened for 2 months ?

Any ideas

 

[theDBguy]

Hi. Are you sure you couldn't just use a query to calculate and show interest earned?