Page MenuHomePhabricator

The most commonly used date format in the Czech Republic produces wrong date when used as a value in Wikidata
Open, Needs TriagePublic

Description

The most commonly used date format in the Czech Republic (and in many other countries, I suspect) is as follows:

DD. MM. YYYY

Or, optionally, without the spaces:
DD.MM.YYYY

However, inserting this date format swaps month and day, producing an easily overlooked error.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 16 2019, 2:24 PM
Pppery updated the task description. (Show Details)Apr 16 2019, 3:50 PM
JAnD added a subscriber: JAnD.Apr 16 2019, 6:58 PM

Well, both MM. DD. YYYY and DD. MM. YYYY are used somewhere. Without making use of geolocalization data, it is impossible to tell which one user meant, except cases when DD>12.

Possible solutions:

  • decline this task
  • (no geodata) a preference saying "my dates are always in DD. MM. YYYY
  • geodata and priority of formats based on source country.

According to https://en.wikipedia.org/wiki/Date_format_by_country , MDY is very rare (0.55 Million users).

MDY is mentioned the article several times (Magenta row is the one you mentioned, but there's also Blue (171 millions) and red (329 millions)). That's about 500 millions of users in total. Yes, DMY is more frequent, but MDY is not that rare.

For example USA (Red) does not usually put dots between the codes. So it's MM/DD/YYYY rather than MM.DD.YYYY, which is really quite rarely used.

Fair enough, missed that "little detail" :-).

Blahma added a subscriber: Blahma.Apr 17 2019, 10:32 PM

@Urbanecm: Why geolocalization when we have language settings (or at least an educated guess) per user? It's the same one that shows labels and descriptions in some languages and hides others.

Vojtech.dostal added a comment.EditedMay 22 2019, 10:02 AM

There is also great inconsistency. Why does "7. 12. 1967" produce "1967-12-07" while "7. 1. 1967" produces "1967-07-01"?

JAnD added a comment.May 24 2019, 8:47 PM

There is also great inconsistency. Why does "7. 12. 1967" produce "1967-12-07" while "7. 1. 1967" produces "1967-07-01"?

And problem with certain dates: I wanted to add 1905-06-07. So I typed 6.7.1905 but date was displayed as july instead of june. So I switched nubers and typed 7.6.1905. The result was again as july.

Possible solutions:

  • decline this task

Wat.

  • (no geodata) a preference saying "my dates are always in DD. MM. YYYY

Right. Which we basically have; even though I would say you should not choose “my date format”, you should choose your language. Which you do, obviously. And it is completely obvious what date was meant by any Czech-speaking user who wrote “7. 1. 1967”.

  • geodata and priority of formats based on source country.

We don’t do i18n based on geolocation, I believe. And I see no reason why we should.

(See also sortable tables with dates in them.)