DD/MM/YY and YY/MM/DD are the only acceptable ones IMO. Throwing a DD in between YY and MM is just weird since days move by faster so they should be at one of the ends and since YY moves the slowest it should be on the other end.
I think most Americans do. Or at least it was taught that way in school when I was growing up. Maybe it’s because of the way we speak dates, like “October 23rd” or “May 9th, 2005”.
Regardless, the only true way to write dates is YYYY-MM-DD.
If you use DD/MM/YYYY, dumb sorting algorithms will put all of the 1sts of every month together, all of the 2nds of every month together, etc. That doesn’t seem very useful unless you’re trying to identify monthly trends, which is fundamentally flawed as things like the number of days in the month or which day of the week a date falls on can significantly disrupt those trends.
With MM/DD/YY, the only issue is multiple years being grouped together. Which may be what you want, especially if the dates are indicating cumulative totals. Depending on the data structure, years are often sorted out separately anyways.
YYYY/MM/DD is definitely the best for sorting. However, the year is often the least important piece in data analysis. Because often the dataset is looking at either “this year” or “the last 12 months”. So the user’s eyes need to just ignore the first 5 characters, which is not very efficient.
If you’re using a tool that knows days vs months vs years that can help, but you can run into compatibility issues when trying to move things around.
The ugly truth no one wants to admit on these conversations is that these formats are tools. Some are better suited to certain jobs than others.
Japan is YYYY-MM-DD, but when we talk about dates where a year is unneeded, we just cut it off which leaves it in the US standard format of MM-DD, much to the annoyance of non-US foreigners living here.
You only think it fits with how it’s read in English because that’s how you grew up saying it so it sounds natural to you.
Your experience is not universal, and is in fact, a minority.
It’s how it is read in English (simplified) aka american english. Brittish english doesn’t do this nonsense, the talk in the correct format (first of january etc.).
(I’m sorry if i made some mistakes, english is my second language)
I grew up with DD.MM.YYYY. But I think, MM/DD makes sense in everyday usage. You don’t often need to specify dates with year accuracy. “Jane’s prom is on 7th September” – it’s obvious which year is meant. Then it’s sensible to start with the larger unit, MM, instead of DD.
Even in writing you see that the year is always given like an afterthought: “7th September**,** 2023“.
DD/MM/YY and YY/MM/DD are the only acceptable ones IMO. Throwing a DD in between YY and MM is just weird since days move by faster so they should be at one of the ends and since YY moves the slowest it should be on the other end.
I’m not kidding when I ask: are there really a lot of people using MM/DD/YYYY??
Almost 350 million of us morons down south of you.
🤣
Using a different date format that means the exact same thing anyway does not make you a moron.
My favourite thing is that files are sorted automatically by date if you use yyyy-mm-dd. Sometimes there are just practical reasons.
But there are a lot of other things that do 👈😎👈
I think most Americans do. Or at least it was taught that way in school when I was growing up. Maybe it’s because of the way we speak dates, like “October 23rd” or “May 9th, 2005”.
Regardless, the only true way to write dates is YYYY-MM-DD.
Thanks!
Pretty much every American I’ve ever met. Dates on drivers license, bank info, etc - all in MM/DD/YYYY … or even just MM/DD/YY
I regularly confuse people with YYYY-MM-DD
If you use DD/MM/YYYY, dumb sorting algorithms will put all of the 1sts of every month together, all of the 2nds of every month together, etc. That doesn’t seem very useful unless you’re trying to identify monthly trends, which is fundamentally flawed as things like the number of days in the month or which day of the week a date falls on can significantly disrupt those trends.
With MM/DD/YY, the only issue is multiple years being grouped together. Which may be what you want, especially if the dates are indicating cumulative totals. Depending on the data structure, years are often sorted out separately anyways.
YYYY/MM/DD is definitely the best for sorting. However, the year is often the least important piece in data analysis. Because often the dataset is looking at either “this year” or “the last 12 months”. So the user’s eyes need to just ignore the first 5 characters, which is not very efficient.
If you’re using a tool that knows days vs months vs years that can help, but you can run into compatibility issues when trying to move things around.
The ugly truth no one wants to admit on these conversations is that these formats are tools. Some are better suited to certain jobs than others.
Should just burn it all down and do. MM/YY/DD
I hope you mean YYYY, not just YY
Japan is YYYY-MM-DD, but when we talk about dates where a year is unneeded, we just cut it off which leaves it in the US standard format of MM-DD, much to the annoyance of non-US foreigners living here.
The only reason they place month as first is because it is fits how dates are read in English, but that’s not a good reason to keep that format.
You only think it fits with how it’s read in English because that’s how you grew up saying it so it sounds natural to you. Your experience is not universal, and is in fact, a minority.
It’s how it is read in English (simplified) aka american english. Brittish english doesn’t do this nonsense, the talk in the correct format (first of january etc.).
(I’m sorry if i made some mistakes, english is my second language)
I grew up with DD.MM.YYYY. But I think, MM/DD makes sense in everyday usage. You don’t often need to specify dates with year accuracy. “Jane’s prom is on 7th September” – it’s obvious which year is meant. Then it’s sensible to start with the larger unit, MM, instead of DD.
Even in writing you see that the year is always given like an afterthought: “7th September**,** 2023“.
So when you say it out loud you say 7th September, and not September 7th?
I say “The 7th of September” because I was taught British English in school.
Americans still use it in rare cases, like the Fourth of July