Apache OpenOffice (AOO) Bugzilla – 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
Last modified: 2013-02-07 22:40:50 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.
Reassigned to Bettina.
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
Add the ISO 8601 week: IYYY-Www, IYYY-Www-D (IYYY is the ISO year, ww is the ISO Week, W is a designator)
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
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)
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.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".