Issue 25424

Summary: ISO standard date formats (YYYY-MM-DD, YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) in the date format picklist
Product: Impress Reporter: ooo
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P2 CC: issues, nsaa.wikipedia
Version: 680m22   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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 
* 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. 
 
OpenOffice.org 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 
use.
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

http://www.iso.ch/iso/en/prods-services/popstds/datesandtime.html

http://dmoz.org/Science/Reference/Standards/Individual_Standards/ISO_8601/

The final document (Expensive CHF 104):
http://www.iso.ch/iso/en/CatalogueDetailPage.CatalogueDetail?
CSNUMBER=26780&ICS1=1&ICS2=140&ICS3=30

The last draft publicy available
ISO 8601:2000 Second Edition [Final Draft 2000-12-15] (PDF 185KB). 
http://www.pvv.org/~nsaa/8601v2000.pdf
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):
http://isotc.iso.org/livelink/livelink/4021199/ISO_8601_2004_E.zip?func=doc.Fetch&nodeid=4021199

See more information on Wikipedia:http://en.wikipedia.org/wiki/ISO_8601
Comment 5 nsaa 2007-10-07 10:30:58 UTC 
Examples on the week format (from http://www.probabilityof.com/ISO8601.shtml): 
'    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".