Hi Phill, > Basically if you create a query (I did it against a MySQL db via ODBC) > that contains a date field. Try entering the following dates:
With "Try entering" we still mean to enter the date into the "Criterion" field, don't we? > c. 1st Dec 2004 in UK format, '01-12-2004' and it suddenly changes to > the USA format, rewriting it as #12/01/2004# which it then treats as a > UK date (thinking it is 12th January 2004). *sigh*. Cannot reproduce. For me (on both Linux and Windows, "Tools/Options/Language Settings/Language/Locale Setting" being "English (UK)", with m80, and all other versions I tried, both when connecting via JDBC or ODBC) this is changed to "#01/12/2004#", which is the expected result. I'm running out of ideas where to search :( > 3. Shall I continue with the existing bug, > http://www.openoffice.org/issues/show_bug.cgi?id=26655 , or file a new one? Continuing with the existing one is fine me thinks. Ciao Frank -- - Frank Sch�nheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems, Inc. http://www.sun.com - - OpenOffice.org Database Access http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
