Hi, there.
I'm trying to execute a simple sql query in Access 2003 and one of my fields is of type date.

I want the date to be stored in format dd/mm/yyyy but Access automatically changes it to mm/dd/yyyy.

All my local settings are dd/mm/yyyy but Access still does the change.

Can U help me?

These are the Access instructions for this issue:
"Change the default country/region
Changing the default country/region changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region.

On the Microsoft Windows Start menu, point to Settings, and then click Control Panel.

Double-click the Regional Options or Regional Settings icon.

In the Your locale (location) list, select the country/region you want to use as the default.

If you are using Microsoft Windows 2000 and don't see the item you want, first select the check box next to the appropriate language in the Language settings for the system box.

Click OK, and then restart your program.

Note When you change the country/region in the Your locale (location) list, settings, such as the format for displaying currency and date, may also change. Check all the tabs in the Regional Options dialog box to make sure they are correct."

If this doesn't work, you can do the SQL work around and have three columns for the date:

DD = DatePart("d", Date)
MM = DatePart("m", Date)
YY = DatePart("yyyy", Date)

Or sort out the dates in an array by breaking them down and then reassembling them for your code - which is a pain, or breaking them down and reassembling them for display only.

HTH


mmcdonal

Thank you my friend. I've tried the three column approach and it works fine. A little more work in the sorting SQL statements I use but the problem is solved.

Much appreciated!!!