The Acc97 database uses VBA to update fields in several tables using Date() and Now() functions. With Now(), it uses CurrentDB.Execute with an SQL statement, while with Date(), it populates a bound textbox. The database is used by multiple people, and is replicated across a WAN.
On one of the computers, it has updated one of the fields incorrectly -- the one using Now() in an SQL statement. When I check the actual field contents using CDbl(DateFieldName), the value is about 39488. By comparison, all the other entries in all the other tables are about 37537, which AFAIK is the correct Julian number for today's date.
Different computers use different Regional Settings (I am in English Canada, the other computer is in Quebec). My understanding was that the computer's regional setting didn't affect how the date was stored, only how it was displayed. However, there is an incorrect value stored in the table. And it is incorrect only in the table that used the Now() function in the SQL statement -- the Date() function in the bound textbox works properly.
How do I fix this problem? Thanks in advance.