Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
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: | code | Assignee: | 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
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". |