Issue 117480 - date entry in Form grid ignores data entered in ISO 8601 format.
Summary: date entry in Form grid ignores data entered in ISO 8601 format.
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-03-20 18:18 UTC by rene
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description rene 2011-03-20 18:18:34 UTC
From, filed against libreoffice but obviously also present in

--- 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, but I think this hasn't too much attention I think...
Comment 1 r4zoli 2011-03-21 08:00:54 UTC
Your bugreporter if prefer YYYY-MM-DD format can easily set it in datefield properties, general tab, "Date format" property to this format.

I think it is more an enhancement, than defect to add some more check formats when date entered into form, to not cause such problem described in your post.
Comment 2 Frank Schönheit 2011-03-22 09:07:33 UTC
didn't look into this in detail, yet, but a general comment: entering dates in ISO format should be supported for years now, regardless of the actual output format of the date. Seems something broke here.
Comment 3 Frank Schönheit 2011-04-04 12:43:34 UTC
ah - didn't read the original description properly. The culprit here is the default used by the form wizard: it creates date fields, which indeed don't have the feature of recognizing the ISO variant of a date. Instead, you'd need to use a formatted field for the feature to work.

So, this is indeed a request for enhancement - either let the form wizard use formatted fields for a date column, or let date fields also recognize the ISO format.
Comment 4 Oliver-Rainer Wittmann 2012-06-13 12:17:49 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.