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
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
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.
deleted by creator
When you write code and call any language's default
sortfunction, it will correctly sort YYYYMMDD but not DDMMYYYYThe Google sheets and excel sort works because the coders have specifically programmed to detect every popular date format and then sort accordingly
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
deleted by creator
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
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.