I am using the following calculation to determine the number of days that have elapsed since a document was submitted for review.

If(Date Rec <> "",

(Date Rec - Date to) * 1,

(Date to - Today)* (-1))

On 7/20/2001 the user (via browser) sees this (calculation works):

Date submitted: 7/19/2001

Date returned:

Days in review: 1

On 7/23/2001 the user (via browser) sees this (calculation doesn't work):

Date submitted: 7/19/2001

Date returned:

Days in review: 1

If I edit the record via browser and change the date submitted to 7/20/2001, it correctly calculates 3 days; when I change the date submitted back to 7/19/2001, it correctly calculates 4 days.

Any idea why it would show "Days in review: 1" instead of "Days in review: 4" when it was first accessed via browser?

Thanks

Instead of the Today function, use status(CurrentDate) and make it unstored.

Values based on the Today function are recalculated when the database is closed and re-opened.

Excellent!

Thank you