Best way to recalc stored calculations
I have a table with a lot of date calculations. Because of the performance I choose to make the calculations stored.
My questions is, what is the best way to to perform a recalculation. I know the stored calculations only update when one of the fields is changed and/or on commit record. But, within the calculation the current date is also used, so I need an update every day the database is opened by the user, even when the user doesn't change the record.
E.g. The user prints a report with "end dates" every week, without editing records. Without a recalculation I get the wrong dates.
Thanks in advance,