I'm with OP, year-month-day is the superior format. Its consistently sortable, even as a text field (like with file names).
Saturday Morning Breakfast Cereal
Posts and discussion about the webcomic Saturday Morning Breakfast Cereal by Hugo Award-winning author Zach Weinersmith (and related works)
https://www.patreon.com/ZachWeinersmith
New comics posted whenever they get posted on the site, and old comics posted every day until we catch up in a decade or so
for storing/filing I agree but for normal use d-m-y makes more sense to me. it frontloads the most relevant information and you can cut it at either break and it could still be helpful, since one's likely to remember the month they're in and even more likely to remember the year. more significant is less relevant.
h:m:a makes more sense for the opposite reason. less significant units of time become less relevant at that scale.
in any case, ascending or descending is demonstrably better than whatever the fuck m-d-y is.
Theoretically, sure, but in reading and speech it doesn't really matter if you're comfortable with the format. If someone is going to say or write the full date you're not going to interrupt them after they say the day or reflexively stop reading after two numbers. If they just want to say the day, that's all they'll say.
If you read the digits in reverse it matches ISO 8601.
And yes I know it's a joke (:
ISO 8601 is the only right way. Easy to read and write and trivially sortable.
Great for dating files, too. We have an otherwise exceptionally inefficient routing chain at work, but we're required to start each file with the date it was created (e.g. 20250101 Johnson Commendation) and it works beautifully for finding files and knowing how long they've sat in someone's "bucket" even though a hard copy is being delivered office-to-office (but final memo needs to be signed digitally). sigh
The format of the date is somewhere around #9000 on my list of shit to worry about in real life.
Edit: I'm dealing with conflicting date time formats in SQL databases and this is now issue #8000 in my life