22
metaory
7y

[YYYY]-[MM]-[DD] or [DD]-[MM]-[YYYY]

Across all dashboards and clients we have in current company you'll find one of the above,
Every developer who ever worked on part of the system have chosen either one..

So it's a total mess,
In an attempt to standard all date formats across all our clients I setup a Slack poll,

And guess which one is winning by more than 2x votes!!
[DD]-[MM]-[YYYY] !!!

And here I thought ISO-8601 is enough reason,
But apparently not!

They say our users are more familiar with the other one,,,

It seems main problem is with the education system of this country,
That's how they were thought in schools,

So... FUCK WORLD'S STANDARDS

Comments
  • 5
    btw all members of tech department voted for ISO, except one dude,,
  • 14
    "The great thing about standards is that you have so many to choose from"
  • 8
    Btw. [YYYY-MM-DD] hands down, anyday!!
  • 17
    Problem with [DD]-[MM]-[YYYY] is that this confuses north american people, as they use [MM]-[DD]-[YYYY] (which is BTW the most moronic way to write a date).

    ISO8601 is unambiguous and by far the best format, but it's not common outside the technical world. It happened to me several times that someone couldn't even identify it as a date.
  • 4
    @ddephor My problem exactly with the ISO standard... For sorting stuff it's the best, but for user-friendliness, at least in Europe and most parts of the world (except, ahem, North America as you said, I'm not proud of that being from Canada but hey 🙄), hands down to DD/MM/YYYY as the easiest to understand for *everyone*
  • 10
    Use a sane format internally. localize it in the frontend based on the device / browser / user settings.
  • 1
    @ItsNotMyFault My thoughts exactly! :)
  • 0
    @ItsNotMyFault of course iso date is stored in db,

    mess is the rendered date
  • 1
    Wait I thought the sign was a standard to show what format you were using.
    So:
    mm/dd/yy or dd-mm-yy

    Not:
    mm-dd-yy or dd/mm/yy

    Thats how I learned it in school and has always proven true until I read these comments.
  • 3
  • 3
    There's no standards in the real world. Better just to localize it. There's many libraries just for that purpose so why not just use those. Or build a big database to localize everything like in a e-commerce website that I have contributed which has been translated to 29 different languages.

    If you really need a standard: use some international standard. If you need to focus on one contry or a region: use it's standardized formats.

    We finns use dd.mm.yyyy, but out there is a complitely different world.
  • 0
    Use Common Sense
    Year
    -Month
    --Day
  • 0
    @metaory no, of course date is stored as _DateTime_ in database!!!

    _format_ is just a question of representation!
  • 0
    @JohanO haahaa yeah of course,

    Issue is with representing the formatted date with consistency across platforms
Add Comment