Date calculation

[SteveS]

I hope someone can help me with this issue. I designed a database that includes a "date field" and a "calculation field." I named the date field (registration date) and the calculation field (total days).

I want to know the number of days that pass between the current date and the date entered in the date field.

I set the calculation field as the following-("Today-registration date"). This seemed to work fine but you need to exit the database and open it up again for this to work when the date changes. This option would not work on a network setting. I want the correct number of days to automatically update when my pc's clock changes.

I would appreciate any help on this issue.

Steve

[-Queue-]

Use Status(CurrentDate) instead of Today and set the calculation to 'Do not store calculation results' in the storage options.

[SteveS]

Thank you very much, that did the trick!!!!