Auto calculations of field upon startup

[Ed1]

Hi,

I created a field that uses the Today function. The problem is that for this field to automatically update, I have to close and reopen the database everyday. Now this database serves as a host and others connect to it via TCP/IP. Is there any way of it recalculating the Today field without restarting the host database? or for the guests to recalculate with closing the host?

Any replies would be very much appreciated.

[BobWeaver]

This is why it's generally recommended that you don't use the Today function. You can substitute Status(CurrentDate) instead, unless the calculated field needs to be indexed.

[John Caballero]

As implied by Bob's post - make sure you set Status(CurrentDate) to be unstored.

[BobWeaver]

Oh right, I forgot to mention that rather important point. Thanks John.