My ASP pages saves a date string (in Access) as:

UPDATE TABLE SET REPORTDATE = #dd/mm/yyyy#;
UPDATE TABLE SET REPORTDATE = #06/11/2006#;

If I open the table in Access the column (MediumDate) will show as:

06-NOV-2006

When I reopen the record with ASP

Response.Write rs("REPORTDATE")

... I get 11/06/2006

I have changed the design for the column to show as a ShortDate which produces 11/06/2006, but still have an ASP page producing a date from June.

Any help to providing a decent fix for this, would be appreciated.

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

It has been a long time since I used Access but you may want to try this select statement. (This may or may not work, but I know it to work in MSSQL)

SELECT
    Convert(varchar(10), REPORTDATE, 101) as [REPORTDATE]
FROM
   [YourTableNameHere]


-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

There's a fair chance your data has been changed due to the regional settings on your server. So, 6/11 is interpreted as June 11th instead of November 6th.

One way to insert data to circumvent this problem, regardless of the regional settings, is with the ISO format:

#yyyy/mm/dd#

This date is always interpreted in the correct format.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.