• GaveUp [she/her]
      ·
      edit-2
      2 years ago

      When you write code and call any language's default sort function, it will correctly sort YYYYMMDD but not DDMMYYYY

      The Google sheets and excel sort works because the coders have specifically programmed to detect every popular date format and then sort accordingly

      • edge [he/him]
        ·
        2 years ago

        The Google sheets and excel sort works because the coders have specifically programmed to detect every popular date format and internally convert it to the objectively best format

        • GaveUp [she/her]
          ·
          2 years ago

          True, but it's obviously best to have 1 standard for date formatting and that's really the most important factor I can think of

          99.99+% of all software are used by non coders. And as coders, it is our job to make our software as easy and pleasant to use as possible for all of our users :)

          As long as DDMMYYYY is the standard, we will adhere to that standard and put in the extra work on our side so the users won't have to

        • nabana [they/them]
          ·
          edit-2
          2 years ago

          Just because someone else spent a lot of effort solving a problem that didn't need to exist in the first place doesn't make it a trivial problem to have solved and still be having to solve. The labor hours wasted on supporting batshit time formats is absurd. Even BEFORE you include all the hours wasted on bugs and side effects and issues (which in some cases have literally killed people) that resulted from just not using a sane format.