Date value issue in Recrodset and Server 2003

[Chris]

I have an issue that is rather odd.

I am moving a website to a Server 2003 box from 2000. On a page that
displays dates from a query in an Access database I get two different result
formats for the date. On the 2000 box I get mm/dd/yyyy, on the 2003 box I
get dd/mm/yyyy.

Can anyone help me correct this issue so it always displays mm/dd/yyyy.

Thanks,
Chris

 

[Mark Hinnebusch]

Sounds like you have mismatched locale settings. One form
that you are getting is the US locale and the other is
European. My guess is that Access uses this setting to
determine default date formats This should be a machine
setting accessed from the control panel, regional options,
date.

-mark

 

[Chris]

Hi Mark,

We've triple checked all of that. I added an extra Date.parse method to a
call to convert the stored XML value to a Date object and it worked.
However, the problem now appears to be in the submission process, Access
flips dd and mm if the day is less than 12.

Any ideas?

 

[Douglas J. Steele]

Regardless of what the short date format has been set to, Access will always
assume that nn/nn/nnnn is mm/dd/yyyy.

You might find Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html useful reading.

 

[Chris]

Hi Doug,

Thank you for your reply. I've read hundred of articles about this,
however, none of them seem to have to real solution.

Regional Settings have no effect in this instance. We're running a
WinServer 2003 machine with Office 2003, MSXML4 parser. On 2000 everything
is fine.

I'd be happy to send you the URL to see for yourself. It's a weird problem.

 

[Chris]

This only happens when the day is less than 12.

Regardless of what the short date format has been set to, Access will always
assume that nn/nn/nnnn is mm/dd/yyyy.

You might find Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html useful reading.

 

[Douglas J. Steele]

When you're having the problem, how is the date being input?

If it's input using a dd/mm/yyyy format, then Access is always going to turn
that around for days of 12 or less, regardless of the regional settings. In
other words, if you key in 02/10/2003, it's going to be treated as 10 Feb,
2003, not as 02 Oct, 2003. If you key in 13/10/2003, Access realizes that
there's no month 13, so it will treat it as 13 Oct, 2003.

Assuming you're using SQL statements to update the table, format the date
explicitly yourself when creating the SQL statement.

 

[News]

The administrator says it's correct. However,

Sounds like you have mismatched locale settings. One form
that you are getting is the US locale and the other is
European. My guess is that Access uses this setting to
determine default date formats This should be a machine
setting accessed from the control panel, regional options,
date.

-mark

 

[News]

Thanks for your reply.

The adminisrator tells me the regional settings are correct (I'm working
remotely). The Session.LCID is different on both machines, however, they
both refer to the same name, English US and default (which is English US).

What I am finding out is that during a conversion to XML from the Recordset
the month and day gets flipped. The straight Recordset value is correct.
Nothing in the code tells it to do this.

Any ideas?