I have a MDB database ( no surprise there )
the date is stored as a text field ( yes deliberately )

The date is extracted using
SELECT Format$(CDate(Left([FileDateTime],10)),'dd-mm-yyyy') AS gdate FROM Header GROUP BY Format$(CDate(Left([FileDateTime],10)),'dd-mm-yyyy') ORDER BY CDATE(Format$(CDate(Left([FileDateTime],10)),'dd-mm-yyyy')) DESC;
Which works fine in access and returns as 01-04-2004 for 1st April 2004
however when using the same SQL statement through ASP it formats it as 04-01-2004 so 4th January.
Regional settings are set to UK, and everything else is fine...

Any clues or tips anyone..
have tried breaking it down with DatePart also, but it seems to be when it executes the SQL over the Jet.OLEDB connection

resolved it by having converted all the string dates to yyyy/mm/dd dates, although still don't understand why it converts it to US format when all the regional settings everywhere are UK

http://www.flws.com.au/showusyourcod...te.asp?catID=3

sorry about the pageslap as an answer, but I still haven't found the answer to the question I'm looking for that lead me to your thread . . .

Hi SeanW,

This has been discussed in another thread. You can take a look at this

Cheers!

_________________________
-Vijay G
Strive for Perfection