Issue 25424 - ISO standard date formats (YYYY-MM-DD, YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) in the date format picklist
Summary: ISO standard date formats (YYYY-MM-DD, YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:...
Alias: None
Product: Impress
Classification: Application
Component: code (show other issues)
Version: 680m22
Hardware: All All
: P2 Trivial with 7 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-02-12 16:16 UTC by ooo
Modified: 2013-02-07 22:40 UTC (History)
2 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 ooo 2004-02-12 16:16:27 UTC
When I have created a date field it isn't possible to select either of the ISO 
date and time formats when you right-click a selected date field: 
* YYYY-MM-DD hh:mm 
* YYYY-MM-DD hh:mm:ss 
Maybe the last one could be omitted but the first two are essential. 
This is also a problem in Draw. as an Open Source project should follow open standards where 
ever there is one because open standards is one of the best weapens against 
close source compatitors when governments have to decide which products to 
Comment 1 wolframgarten 2004-02-13 07:35:51 UTC
Reassigned to Bettina.
Comment 2 nsaa 2004-05-04 13:28:37 UTC
More information about the standard that covers this issue (ISO 8601 Data 
elements and interchange formats -- Information interchange -- Representation 
of dates and times) can be found here

The final document (Expensive CHF 104):

The last draft publicy available
ISO 8601:2000 Second Edition [Final Draft 2000-12-15] (PDF 185KB).
Comment 3 nsaa 2007-10-07 10:07:00 UTC
Add the ISO 8601 week: IYYY-Www, IYYY-Www-D (IYYY is the ISO year, ww is the ISO
Week, W is a designator)
Comment 4 nsaa 2007-10-07 10:11:08 UTC
The ISO 8601:2004 standard (for free from ISO):

See more information on Wikipedia:

Comment 5 nsaa 2007-10-07 10:30:58 UTC
Examples on the week format (from 
'    January 4th. 1993 is on a Monday(1993-01-04)
'        1993-01-03 -> 1992-W53-7
'        1993-01-04 -> 1993-W01-1
'    January 4th. 1998 is on a Sunday (1998-01-04)
'        1997-12-28 -> 1997-W52-7
'        1997-12-29 -> 1998-W01-1
'        1998-01-04 -> 1998-W01-7

'    Year start at a Thursday
'        1998-01-01 -> 1998-W01-4 (i.e a Thursday)
'        1998-12-31 -> 1998-W53-4 (->Leap week!)
'    Year start at a Wednesday and is a Leap year
'        1992-01-01 -> 1992-W01-3 (i.e a Wednesday)
'        1992-02-29 -> 1992-W09-6 (and a Leap Year)
'        1992-12-31 -> 1992-W53-4 (->Leap week!)
'    Year start at a Wednesday and is NOT a Leap year
'        1975-01-01 -> 1975-W01-3 (i.e a Wednesday)
'        1975-02-29 -> ERROR, No date, No Leap year
'        1975-12-28 -> 1975-W52-7
'        1975-12-29 -> 1976-W01-1 (No Leap week in 1975)
Comment 6 conficio 2008-07-31 19:39:07 UTC
This is also an issue in Impress, for the slide format the date field. 

It is also inconsistent with Calc, which does support those date formats.
Comment 7 bettina.haberer 2010-05-21 14:55:43 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".