AnsweredAssumed Answered

Best way to recalc stored calculations

Question asked by lijnbach on Jul 23, 2015
Latest reply on Jul 26, 2015 by lijnbach

Title

Best way to recalc stored calculations

Post

Hello everybody,

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,

Hans Lijnbach

Outcomes