Issue 117480

From http://bugs.debian.org/617595, filed against libreoffice but obviously also present in OpenOffice.org:

--- snip ---
My system has a default locale of en_US.  This means that dates
rewritten to match my locale come out like 02/27/11 (for 2011,
February 27th).  I prefer to enter dates in ISO-8601 format
(2011-02-27) because of its lack of ambiguity.  (i actually prefer to
view them that way too, but i haven't sorted out how to do that yet).

I start a fresh database with libreoffice-base.  Make a new table with
a Date [DATE] column in it.

If i edit the table directly, i can enter dates in ISO-8601 format and
they get stored properly.

>From Forms, choose "Use Wizard to Create Form", and click "finish" to
get the default form with a grid view.

Open the form, and enter the date in ISO-8601 format.  no matter what
date i enter, it gets re-written to today's date (03/09/11).  It would
be pretty easy to enter a dozen dates before realizing tha the
rewriting is getting it wrong :(

If i enter a date in the locale format, it is accepted properly.  Then
if i go back and re-enter it (for the same record) in ISO8601 format,
the old date is retained (rather than being set to the today's date).
--- snip ---

I found http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=26745&start=0, but I think this hasn't too much attention I think...