Issue 22190 - Date format for South African locale is incorrect
Summary: Date format for South African locale is incorrect
Alias: None
Product: Internationalization
Classification: Code
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P5 (lowest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2003-11-06 10:19 UTC by antonbijl
Modified: 2018-08-31 01:53 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description antonbijl 2003-11-06 10:19:52 UTC
The date format for the OOo South African locale is incorrect. The format in 
OOo is MM/DD/YYYY, but the South African standard is YYYY/MM/DD (although 
DD/MM/YYYY is also frequently used, but never MM/DD/YYYY).

BTW, I tested this by inserting a date into the header of a spreadsheet using 
the date insert button on the header edit dialog in Calc. This inserts a date 
in the standard format associated with the locale and it works for other 
locales (e.g. for Swiss German it inserts DD.MM.YYYY). For South Africa however 
it inserts MM/DD/YYYY, which certainly isn't the South African standard date 
Comment 1 antonbijl 2003-11-11 17:00:19 UTC
The following URL describes the standard format for the South African 
Comment 2 Dieter.Loeschky 2003-11-20 17:11:13 UTC
DL->ER: Could you please takeover?
Comment 3 ooo 2003-11-24 15:50:17 UTC

i18npool/source/localedata/data/en_ZA.xml simply references en_US
values and only overrides currency.
Comment 4 ooo 2004-03-14 18:20:16 UTC
Fixed on branch cws_srx645_pp3calc:
Comment 5 ooo 2004-03-16 12:55:47 UTC
Had to reverse dependencies for linkage reasons, af_ZA partly references en_ZA
now, and hopefully got the data and references right now (were always wrong in
en_ZA), latest fixes on cws_srx645_pp3calc:
Comment 6 oc 2004-03-30 15:33:26 UTC
reassigned to qa
Comment 7 oc 2004-03-30 15:34:23 UTC
reset resolution to fixed
Comment 8 oc 2004-03-30 15:34:58 UTC
verified in internal build cws_pp3calc
Comment 9 oc 2004-03-30 15:35:23 UTC
Comment 10 frank 2004-04-23 14:43:31 UTC
Found integrated on Windows, Linux and Solaris
Comment 11 Unknown 2010-07-12 00:05:00 UTC
Created attachment 70532
Comment 12 Unknown 2010-08-24 12:17:50 UTC
Created attachment 71301
Comment 13 Unknown 2010-08-25 12:49:13 UTC
Created attachment 71360
Comment 14 dcarterza 2016-01-19 05:21:11 UTC
The correct date format for South Africa is YYYY-MM-DD, though DD-MM-YYYY is also commonly used. YYY/MM/DD is wrong. 

Please reopen this bug.
Comment 15 dcarterza 2016-01-19 05:25:09 UTC
Correction to above comment. Meant to say "though DD/MM/YYYY is also commonly used"
Comment 16 orcmid 2016-01-19 16:17:59 UTC
(In reply to dcarterza from comment #15)
> Correction to above comment. Meant to say "though DD/MM/YYYY is also
> commonly used"
Granted.  The Wikipedia account is not authoritative but it is definitely clear.

(Aside to folks who confirm/explore this: Please note that the presentation of the date in the cell to the user is not the same as how the date is stored in the document file.  People looking at this defect need to be clear that this is about formatting the presentation of the cell and the editing of input values into the cell.  This also means that when the file is interchanged between users operating with different locales there can be deviations in the observed presentation and recognized formats depending on various factors.)
Comment 17 orcmid 2016-01-19 16:20:29 UTC
(In reply to dcarterza from comment #15)
> Correction to above comment. Meant to say "though DD/MM/YYYY is also
> commonly used"
I am making this unconfirmed to invite clear confirmation of this.  

Please update the version of Apache OpenOffice "Latest Confirmation In" entry and also the specific platform used.
Comment 18 orcmid 2016-01-19 16:21:27 UTC
(resetting obsolete Assigned To and QA Contact
Comment 19 Gert van den Berg 2018-08-30 19:03:43 UTC
South Africa adopted ISO 8601. (The description should be sufficient)