November 25, 200322 yr Newbies 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.
November 25, 200322 yr 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.
November 25, 200322 yr As implied by Bob's post - make sure you set Status(CurrentDate) to be unstored.
Create an account or sign in to comment