Re: date default settings on Access

colmkav wrote:
thx. the windows setting which I have changed resolved them problem.
Not sure what you mean in the second part. Surely if you set the
windows settings to English dates Access will not treat dates as
English ones.

when I called dateadd("d", 1, dt). where dt is the date 1/5/2007. I
get 2/5/2007 returned. before I made this change I got 1/6/2007.

What cases does Access choose US?

As stated, when using literal date strings in queries or code.

UPDATE TableName
SET DateField = #1/9/2007#

Will result in that field being updated to January 9th 2007 regardless of
the regional settings in Windows. If you wanted September 1st you would
need to use a non-ambiguous format like...

#1-Sep-2007#
#2007-09-01#
#September 1, 2007#

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.