date calculation

[sdondero]

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

[dspires]

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.

[sdondero]

Excellent!

Thank you