Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Now() and Today()

The Now() and Today() functions are called volatile functions and can cause problems in Jet Reports because they recalculate each time there is a change in the worksheet which can add significant processing time for the report. Jet Reports makes large numbers of changes to the worksheet while it runs and each of those changes can cause a recalculation of the entire worksheet if you have a volatile function on the worksheet.

To avoid issues with volatile functions, use the NP ("Eval") function.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request