News for hackers. Stuff that matters.

A comment on Scientists rename human genes to stop MS Excel from misreading them as dates. Parent comment

Re:Scientists rename human genes to stop MS Excel from misre... by eitland on Thursday August 06, 2020 @02:41PM (#24074088)
I think you misread: most of mainland Europe including Germany use dd.mm.yyyy or something else that is reasonable sane even if it isn't sortable like yyyy-mm-dd. Or am I wrong on this? Norway at least use mm.dd.yyyy and never mm/dd or mm.dd.yyyy
[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by pintxo on Thursday August 06, 2020 @04:07PM (#24074905)
Afaik Norway also uses the sane format: DD.MM.YYYY

See parent source: https://en.wikipedia.org/wiki/Date_format_by_country

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by eitland on Thursday August 06, 2020 @05:08PM (#24075480)
Edit: of course. To late to edit but if you read my post, but that was what I meant.
[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by lioeters on Thursday August 06, 2020 @03:46PM (#24074701)
> The format dd.mm.yyyy using dots is the traditional German date format.

> Since 1996-05-01, the international format yyyy-mm-dd has become the official standard date format

https://en.wikipedia.org/wiki/Date_format_by_country

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by arrrg on Friday August 07, 2020 @02:43AM (#24079041)
Schools still teach DD.MM.YYYY. That’s what’s relevant because that’s what people actually widely use.

Shouldn’t Americans be very familiar with the idea that official norms (the metric system) play no role if the people don’t want to use them?

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by lioeters on Friday August 07, 2020 @11:14AM (#24082739)
I understand - it seems I was too optimistic to read that the use of yyyy-mm-dd has become "the official standard" in Germany, without considering the popular usage and convention under discussion.
[ Parent | on HN ]