Access Date Format problem on new server ie MM/DD/YY instead of DD/MM/YYYY

Question

I seem to have ran into a problem I thought I had long ago solved

My web host recently changed one of the servers some of my sites are on, and this has caused problems with one site in particular that uses an access database

When inserting dates it seems to now take a date in the format DD/MM/YYYY and record it in the database as MM/DD/YYYY which as you can imagine is causing huge problems

I seem to remember before that this was an issue with how the server was setup, but cannot figure out what to change.

The servers use helm, so each website runs under its own user account, so obviously checking that my own server login is running under a UK profile makes little difference

Answer 1

The answer is to use parameterized queries (including insertions) and never rely on the database formatting of the data. If you have dates and times, you should always be dealing with those as dates and times instead of strings. When you query, fetch the result as a date time. When you insert/update, or provide dates within the query, provide those values as parameters with the appropriate date/time type.

(You haven't said how you're accessing the database, so it's hard to give more specific advice. I'm assuming you're doing it programmatically somehow though.)

Answer 2

Sorry guys, I should have continued googling a little more before I posted here, in trying to find a quick workaround by setting the session.localid from the asp page i found the root cause/solution!

In Control Panel > Regional Settings you need to change the country/location etc to UK