Issue 3093

Summary: ISO standard date formats (YYYY-MM-DD and YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) in the date format picklist for all applications.
Product: Internationalization Reporter: ooo
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: gerry, issues, robin.laing, stp
Version: 641   
Target Milestone: ---   
Hardware: Other   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description ooo 2002-02-14 10:43:11 UTC
I think it is important that gives the opportunity to use the 
international standardasized date formats as the first options in the picklist 
for date formats.
Comment 1 Dieter.Loeschky 2002-03-25 08:28:51 UTC
DL->ER: I think it might be your task.
Comment 2 ooo 2002-04-03 10:05:16 UTC
er->cs: do you mean to list the ISO formats on top of the list instead of further down?
Comment 3 ooo 2002-04-11 20:00:37 UTC
Claus, could I get an answer regarding my question, please?
Comment 4 ooo 2002-04-15 11:07:50 UTC
I would put the ISO formats at the top.

But the best way would be that the date and time standard listed
first is the language dependable. Then the ISO formats. And at the
bottom all the formats.
Comment 5 ooo 2002-04-15 13:38:25 UTC
Consider using the msgid number format code field of locale data XML
files for UI sorting purposes:

<FormatElement msgid="...">
Comment 6 Unknown 2002-05-26 06:04:54 UTC
Using spreadsheet format to facilitate genealogical studies can only 
handle a 100 year period.  Not too troublesome except cells insist on 
converting to two digit year and prints them that way.  Need ability 
to share information with my European friends in a format that both 
of us can understand.  Today's date is 25 May 2002.  My dates like 25 
Jul 1885 get converted to 07/25/85.  I would like control over that.

I can adjust via the tool set which span of years are covered.  But 
printing the dates with two digit years is confusing.
Comment 7 ooo 2002-05-27 11:19:57 UTC
er->JoeRooney: I don't see your problem. Just use a number format that
displays dates with centuries, for example, YYYY-MM-DD
Comment 8 ooo 2003-01-09 16:07:17 UTC
retarget to OOo Later
Comment 9 ooo 2004-02-12 08:01:26 UTC
Should this be retargeted again? 
It was retargeted over a year ago - and I would really like to see this feature in OOo 2.0. 
And as far as I can see it should be too complicated to add these date and time formats to the 
ones which is already implemented - even if it is only at the bottom of the formats in the list. 
Then we can change the order afterwards. 
The best way open source software can beat closed source software is by using open 
standards. So please reconsider this issue. 
Thanks in advance 
Comment 10 ooo 2004-02-12 14:47:08 UTC

This issue is not about adding ISO date/time formats, but a predefined order of
listing of formats, and to move the ISO formats more to the top of the list. To
have that handled in a more general way it's not just about reordering some
entries, but to provide a mechanism to be able to specify an ordering within the
locale data. So no, no retargeting.

Comment 11 ooo 2004-02-12 16:06:51 UTC
Ok - but Impress still lacks the ISO date format. 
I'll create a new issue concerning this. 
I'm looking forward to the fixing of this issue. 
Thanks in advance. 
Comment 12 grsingleton 2004-02-12 20:11:22 UTC
May I ask that you make one for writer while you are at it. We should be consistent.
Comment 13 ooo 2004-02-12 21:08:59 UTC
You're right - Writer only have YYYY-MM-DD and lacks YYYY-MM-DD hh:mm and 
YYYY-MM-DD hh:mm:ss. It is the same with Calc. 
I create issues for Writer and Calc also. 
Comment 14 ooo 2004-02-13 10:18:34 UTC
Both, Calc and Writer, use the same set of predefined format codes in the number
formats dialog. There is no need for separate issues.

Comment 15 ooo 2004-02-13 10:56:40 UTC
The difference is if they are listed or not. 
The diffent applications have their specific way to select formats for date 
and time. 
In Writer date and time is set by fields and you can select the format 
YYYY-MM-DD but not the other two. But you can write your own format under 
"Additional formats...". 
In Calc you specify the format of the cell and you can select the format 
YYYY-MM-DD but not the other two. But you can write your own format under 
"Format code" in the "Format Cells" dialog box. 
In Impress and Draw date and time is set by fields and you can only use 
formats which is in the drop-down-list when you right click the field. 
Maybe Impress and Draw should implement fields the same way as Write which 
gives the user more opportunities. And not only when it comes to date and time 
Comment 16 mestech 2005-05-30 18:48:47 UTC
To add to this.

This issue was opened in 2002 and it is still not fixed or resolved.  Yes there
are ISO dates in some dropdown menues but there are areas that it has not occured.

In Calc, you cannot set the date format of headers and footers.  It uses the
format as set in the Options selection.  There is no selection for ISO dates in
the options settings for default selection.

Why cannot OOo support "One default setting" for the whole suit and then still
allow customization as required.

I tested this in 1.9.95 today.
Comment 17 grsingleton 2006-07-10 12:48:01 UTC
Added to cc
Comment 18 mestech 2006-07-10 17:56:12 UTC
To add my comment to this issue.

Our locale settings don't reflect the date code that we need to use.  We are
moving to ISO format and when the locale settings are taking over for what we
need as a default setting is a pain.  Especially when headers and footers become

Of course we run into this situation with Microsoft Office as well.

What is needed it a way to set OOo's default formats in the options selections.

To provide an example.  My locale is English Canada but our company date format
is YYYY-MM-DD, not MM/DD/YY.  It makes it hard when I want to insert a date field.

In Linux, there is no way to set the system wide date format (at least easily)
as there is in Windows so the option isn't to change the system default which I
would love to do.
Comment 19 Marcus 2017-05-20 11:13:45 UTC
Reset assigne to the default "".