Date display is driving me nuts

Hi,

same set-up as in my other problems. I have ASP-pages, an IIS and a connecting Access db via ODBC.
Problem is the following:
I have recently migrated the system from my personal notebook to a local server (on my work PC), and then to a test environment. Each time, the date displays are completely screwed up. I am guessing this is due to the fact that for all set-up, I somehow managed to use different languages (English, German, Spanish).
DB entry works fine, cause I have a JS handler to check for correct input, and change that then so Access will handle it. JS is ok in this case, cause my users won't disable it (or they will be fired ;-), just joking).
However, when reading from the DB it always displays the data in a wrong format.
Where is the culprit? The browser (wouldn't think so), the IIS, or Access? Is there an easy solution to fix the prob? I mean, other than checking every date display every time and then manually tweaking the data so it will fit the needed format?


Thank, this is driving me nuts.

It displays the data on the webpage in the wrong format? If that is the case just use formatdatetime() function (for more info, http://www.devguru.com/technologies...atdatetime.html). If those format's don't suite your needs you can always just use the datepart (for more info see, http://www.devguru.com/technologies...f/datepart.html) function to create a function that will format your dat the way you want it.

Thank you.
The problem is the different time formats in German, English and Spanish. I.e. the German date format is dd.mm.yyyy, while in English it is mm/dd/yyyy, obviously.
But I will give the DatePart() function a try.

Thanks for the hint!

Merry Christmas to you.

The english date is also dd/mm/yyyy. It is the americans who have their date as mm/dd/yyyy.

I would look at the settings on your server, if your server is setup within america or has an american loaded format then you will need to change it to the Engish format (or the geman format in your case).