Date dd/mm/yyyy problem

Guest · Dec 15, 2003

Hello al

My office recently insisted that we adjust our date format to dd/mm/yyyy (I live in the Bahamas. Things are done alittle differently) Anyways I assumed that this would in no way affect my vb app that connect to a access db , but I was wrong

After some investigation, I have narrowed the problem down to my access db. I am running Microsoft Access 2002 SP-1.(and searching updates now.)

I created a query that should return all record up to the 2/12/2003 (2 Dec, 2003). The system however evaluated this as Feb 12 2003, and since there were no records around that time, it returned nothing

I then switch up and searched for records up to 12/2/2003 (this according to my system should be 12 Feb 2003). The system however returned everything up to the 2 Dec 2003

Is there an internal setting in access that I need to adjust in order for this to work properly?
Any help you could offer would be greatly appreciated

Thanks

Van T. Dinh · Dec 15, 2003

Generally, literal dates in SQL Strings must be in US format (mm/dd/yyyy)
and enclosed in hashes like

#12/02/2003# 2/Dec/2003

for JET to interpret correctly regardless of the country settings of your
OS.

--
HTH
Van T. Dinh
MVP (Access)

Andre Gibson said:
Hello all

My office recently insisted that we adjust our date format to dd/mm/yyyy

(I live in the Bahamas. Things are done alittle differently) Anyways I
assumed that this would in no way affect my vb app that connect to a access
db , but I was wrong.

After some investigation, I have narrowed the problem down to my access

db. I am running Microsoft Access 2002 SP-1.(and searching updates now.)

I created a query that should return all record up to the 2/12/2003 (2

Dec, 2003). The system however evaluated this as Feb 12 2003, and since
there were no records around that time, it returned nothing.

I then switch up and searched for records up to 12/2/2003 (this according

to my system should be 12 Feb 2003). The system however returned everything
up to the 2 Dec 2003.

Douglas J. Steele · Dec 15, 2003

In addition to Van's comment (which is absolutely correct), you may want to
take a look at Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)