[Solved] Dateformat while querying the MS Access Data

See more:

MS-Access

Hello All ,

I have one issue regarding the MS access query.

I am using MS Access 2007 and Created the DB and tables.
The tables having the date column. Better say below is the table definition and data.

Id , Member , CollectionDate
1    ABC      12/01/2010
2    DEF      5/1/2010

The first date is 12 Jan 2010 and second is 5 Jan 2010.

But whenever I clicked on datetime picker which pop up when after clicking on date column fields in MS access environment. It Shows 01 Dec 2010 and for second date it shows 1 May 2010.

Also Whenever I used to find the data. I have to query in this way

SELECT * FROM table1 WHERE CollectionDate = #1/12/2010# 

to get the first row and

SELECT * FROM table1 WHERE CollectionDate = #1/5/2010#

to get the second row.


For your information. My system date format is dd/MM/yyyy
But when I installed the MS in my system. That time the date format was MM/dd/yyyy.

Now my question is how can I change the date format of MS access query to make it sync with system date format.