APPLICATION DESIGN
Determining the daily age of a document In your Service Tracking database, you want to track the age of request documents. On the Request form, you create three fields to calculate the information.
The first field is a computed Time field called DateCreated containing this formula:
@Created
The second field is a Time field named CurrentDate containing this formula:
@Now
The third field is a computed Numbers field that is calculated by this formula, which uses the values from the previous two fields:
@Abs(@Integer((CurrentDate - DateCreated) / (60 * 60 * 24)))
IBMR LotusR NotesR stores dates as a number of seconds, so that number is converted to days by dividing it by (seconds per minute [60]) * (minutes per hour [60]) * (hours per day [24]).
See Also