[thelist] Re: Access Date Trouble

[Paul Backhouse]

Josh,
	thats the thing, the value of Now() is the correct date in time in UK
format - thats why I'm stumped (should have said this in the first email -
sorry)

Some how the Access database changes it around and instead of entering 18th
December 2001 it entering 1st December 2018.

The only thing I can thing it is, is that I must have a corrupt file
somewhere thats messing it up - I've rebuilt the database, reinstalled
Access, removed, rerinstalled again - nothing, no change - I'm completely
bewildered - I'm considering rebulding my pc anyway (its getting to that
time), its just a pain in the neck that its not working - I can still finish
the job off properly, just have to make changes to the database on the demo
site - but thats the way its gonna have to be.

cheers paul


>> I would be interested in knowing the value of Now() before it is inserted
>> into the database.  Have you checked this value?  (If you are using ASP,
use
>> "response.write (Now())")  Maybe the issue isn't your database, but your
>> code...