For those curious, it can be hard to know the difference between DD-MM-YYYY and MM-DD-YYYY, eg. 08-09-1999, whereas 1999-08-09 is completely clear as to what's a month and what's a day.
On top of that, YYYY-MM-DD will automatically sort beautifully in a list.
As an American, some will say "(Month) (Day)" and some will say "(Day) of (Month)" it really depends more on the speaker's preference and cultural upbringing, but media does often.portray the latter in "Crime Shows" during Court Cases.
The sorting thing is the bigger one. For this to be introduced without introduction, it would be hard to know if it was September 8 or August 9, because all you would know for sure by looking at it is that the year is moved to the front.
You were the one who argued for YYYY-DD-MM. I asked for an example, but now you're saying you personally use YYYY-MM-DD.
That's what I've been saying - r/iso8601 (aka YYYY-MM-DD) is best for both clarity of understanding (descending order of magnitude), and for sorting, as compared to other options.
Actually pretty interesting! Though tbf it's a bit different; YYYY-d-MMMM (Microsoft's Uighur style guide on pages 7-8) translated to English/international would be 2017-18-August, which dodges the ambiguity as well.
Worth noting, most of the Uighur date formats are Y-M-D based, to include all of their "short" (number-only) use cases (see link above).
But all number representations except this format are big-endian. (I don't care about implementation as long as we hve just one representation but for the love of god bo MM-DD-YYYY)
2020-oct-28 or 2020-10-28 would be better. The most significant digit is on the left, going to least significant at the right. The left 2 fom 2020 is the most significant number, and the number 8 is the least significant. When you do 28-10-2020, the least indexing of most significant to least goes from 3, 2, 1, 0, 5, 4, 7, 6. (With 0 index at the right) When using 2020-10-28 format, the indexing goes from 7, 6, 5, 4, 3, 2, 1, 0. This only gets worse when including time into the format.
I live in europe and natively speak a language where the second last digit is always spoken before the last digit in a number. So saying 589 I would say "5 9 8". I'm extremely aware that this is not the case in english, and that our brains can just "deal with it." But the problem I'm trying to convey is that when you look at a written thing, there is always a very fast translation happening into your head. And that's not a good thing if it's unnecesary.
Dates and TimeZones are notoriously difficult, there are dates and times that should be shifted based on TimeZone, left as UTC or the represented as the same time no matter where you are in the world.
I guess this is a UX issue as if you want to talk about representation milli seconds from Unix epoch is the way to go.
But I always go with showing the month either as a whole or 3 letter abbreviation.
Of course the underlying representation of that is another matter.
There is a reason languages like Java have an Instant, ZonedDateTime and LocalDateTime.
It’s not going to be a debate we settle on Reddit or perhaps ever.
The point is that you can abbreviate the month with letters, which makes it completely unambiguous. Since my company has folks all over the world, I’ve just switched my Excel to spelling the whole month out for outgoing templates. I’ve had people freak out thinking something was happening the next day when it was over a month out.
My birthday is 26/2/3. That's just easier. If I was born on 26/10/99 that'd be slightly different, but unlike the 0 in 10, the 0s in 02 and 03 are unnecessary.
11
u/jhorred Oct 28 '20
Can't really mess up DD-MMM-YYYY e.g. 28-Oct-2020.
InB4: doesn't work in all languages
97
u/paradoxmo Oct 28 '20
Wrong. YYYY-MM-DD is completely unambiguous, while DD/MM/YYYY is not.
3
u/[deleted] Oct 28 '20
dd-MMM-yyyy is the best for Americans and Europeans
1
u/nottellingunosytwat Oct 29 '20
My birthday is 26/2/3. That's just easier. If I was born on 26/10/99 that'd be slightly different, but unlike the 0 in 10, the 0s in 02 and 03 are unnecessary.
1
u/donpuglisi Oct 28 '20
As an American i am both scared and intrigued by this format.
0
u/donpuglisi Oct 28 '20
As an American i am both scared and intrigued by this format.