Hi Phill, > However, if the date is encapsulated inside single quotes then it starts > to misbehave... > 4. > '01-11-2004' (turns into #11/01/2004# and means 11th Jan 2004) > 5. > '11-01-2004' (turns into #01/11/2004# and means 1st Nov 2004) > It seems adding single quotes makes Base think that the date is in the > US format rather than the current locale. > These two steps can be reproduced by using slashes instead of hyphens > too, just so long as they are inside single quotes.
Ahhhhhh! You never ever told about the quotes! :) Can reproduce now, and - even better - roughly know how to fix it :). Would you submit a new issue (instead of re-using the existing one for this now rather special situation), please? Not sure whether the fix will make it into 2.0, but will try. Note: for internal reasons I don't want to elaborate here and now :-\, setting the column to a date format other than the original default one works around the problem. From now on, it works all the time, even if you set the format back to the default one. Ciao Frank -- - Frank Sch�nheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems, Inc. http://www.sun.com/staroffice - - OpenOffice.org Database Access http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
