ISO 8601 format is the best (YYYY-MM-DD).
Came here to say this. I try to name all my docs in the YYYY-MM-DD-descriptive-name.ext format.
I can see some advantages of that.
I’m American though, so YYYY-DD-MM is the best I can do.
for me, the section that changes the most goes last…
in a whole year, the YYYY never changes, the MM changes only 12 times… i never implementing the day… there’s only so many possibilities i could have had for saved files in June. i just go straight to description
I hope that the comment you answer to was ironical. >!Otherwise there’s no hope for us 😰!<
haha yeah. i just assumed they were kidding, but if not… yikes!
I like that for files, but not for written documents. When I label things I try to use the most intuitive/least confusing way I can think of: DD mmm YYYY. This comment is posted on 23 NOV 2023, for example.
I do prefer the abbreviated month with the yyyy mmm dd format. It makes things relatively easy to sort but you also don’t have to worry about confusing others if you are referring to the 10th month or day for example.
The only correct format. Least to most specific.
Used to be my account name on a different website social media aggregator.
For Excel 100%
Best nomenclature for sorting.
YYYY-MM-DD (honestly without dashes) is the only helpful format.
If you name all your files with this as a suffix then your files automatically sort versions of themselves in order when sorting by name.
ISO 8601 baby
Though it ought to be a prefix, not a suffix
You mean as a prefix, right?
Their assumption is that the filename is the same otherwise e.g. myNotes20231122.txt
Oh I see, thanks. Good alternative to final3_release2.
Came here to say this, I use DD.MM.YY in day-to-day stuff, but for files it’s either YYYY_MM_DD or YY_MM_DD, the automatic ordering is beautiful
Yeah this method is superior for digital filing. I can’t imagine the sorting clusters I’d have to go through to find what I want any other way
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 👈😎👈
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.
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“.
It actually makes sense when you put YYYY/MM/DD in filenames as they will be sorted pretty neat (ex: reports)
Yeah for a lot of files you probably would sort by year in the end
It is arguably the best way to name large sets of indexed files on a filesystem.
I think that the best argument is that it makes sense when combined with hours minutes and seconds.
yyyy/MM/dd hh:mm:ss
Goes from large to small units.
It sorts
Japan’s way, you mean?
Yes, YYYY/MM/DD
Files already have computer readable dates that can be used to sort and organize them
In certain instances that may not always be available.
One example I can think of is when browsing on a NAS.
This meme implies there’s an equal battle between MM/DD/YY and DD/MM/YY, which is nonsense. Much like imperial units, only 'murica uses MM/DD/YY.
Oi guvnah, ow many stone chu weigh?
Only one, but it has my exact weight
If you look at the calendar, you’ll see that we are not in 1900 anymore.
No one I know measures their own weight in imperial.
Talking about fuel efficiency in miles per liter 🤣
I have 2 stones if that’s what you’re asking.
But 'murica is big.
Only slightly bigger than Australia and Western Australia is nearly twice the size of Texas…
When talking about cultural mindshare I’d argue that the quantity of people matters more than the space they’ve been packed into
Mercator would like a word.
Mercator can say whatever it wants, it’s not involved in this discussion.
Liberia and Myanmar also use imperial units, but they’re both starting to move towards metric in recent years so soon the US truly will be alone in that
YYYY-MM-DD in Hungary too, that us shit is totally non logical, i cant get used to it
This is literally the most logical method to name a date in text.
In what text?
In French we say “14 juillet 1789”
We don’t even say “nth day of”
In a text like “the research started at 2003-01-24”, or pretty much in any other text where you need to convey all 3 elements.
I bet you also don’t say “14 07 1789”, because that’s what MM format means.
You bet wrong
We write AND say “La Révolution a démarré le 14/07/1789” or “La Révolution à démarré le 14 juillet 1789”
Spoken numbered month are usually used in an administrative context, to ease the work of our contact.
Oh that’s right, the spoken administrative context. Same in my dd-mm-yyyy county actually. Still, I find it less intuitive than the logical yyyy-mm-dd when understanding written text.
Fuckin wait until you hear how many feet are in a mile. You all should’ve waterboarded us harder while we were a young country.
FIvE tOMaToeS
We do that in Sweden as well. Our social security numbers are that plus 4 unique numbers. The beers I send out to stores have yyyy-mm-dd printed at the bottom.
So no more than 10 thousands of Swedes may get an SSN at the same day (or be born at the same day even 🤔)?
Hasn’t been a problem so far. I’m guessing maybe they will add numbers or use letters if it comes up. They recentled started doing that on license plates.
It’s very easy to sort by this format, makes perfect sense.
Easier to sort by YYYY-MM-DD than MM-DD-YYYY tho
Dammit, I misread here. Of course, the US format is terrible.
When you’re naming a file, you can’t use anything else.
You’re not wrong. through much trial and error in the 1990s I learned this was the most efficient & accurate & chronologically searchable way to date things.
MMDDYY is just a mess. Otherwise… US problems, I don’t care…
Not to us burgerland citizens! 🇺🇲🇺🇲🦅🦅💥💥
Massive trucks that increase fatalities. Bald eagles that are endangered because of Americans, and sound like red tailed Hawks for some reason. Fireworks that are more heavily regulated than guns.
I love Americans but your country is run like a ball of yarn in a box of cats.
Bald eagles aren’t endangered anymore.
Plus being American and having lived abroad every country has their bullshit. You just hear about America’s shit because it has the most popular forms of mass media.
Dumbasses are plentiful everywhere
I don’t like all Americans and you are the kind I don’t. You’re an idiot. I was going to say imbecile but I doubt you know what that means.
This will surely keep me up at night.
Didn’t know saying no country is perfect was such a controversial statement
Getting irrationally defensive over facts is the part no one likes. Large trucks kill people at a higher rate. Fact. Bald eagle is still endangered. Red tailed hawk which is the bird that makes the actual sound, endangered. Many states in the us regulate fireworks harder than guns. Acknowledge your faults.
No one was denying anything… all I said was essentially no country is perfect. A pretty level headed response in my opinion
The most American statement ever :DEdit: I am taking it back and admitting defeat. America != US. I am ashamed.
I propose the use of MYDYDM format. So, October 15, 2023 will be written as 121350. Just to make it as confusing as possible.
And then convert that to hexadecimal, making it 1DA06
Welp. I need a bath now.
Amazing
We’re also unduly forgetting about truly little endian date format: DD/MM/YYYY, for instance 52/11/3202 for this Saturday
Also we could just sort the numbers and omit leading zeroes, that way we can save some space, the same date would be 1122235
Iso date format. Anything to do with photos is best to have in this format at the start of the filename.
Iso date format. Anything
to do with photosis best to have in this format at the start of the filename.Fixt.
It also means that by default it’ll sort by newest
YYYY-MM-DD for files, DD-MM-YYYY for normal use
Wtf why
Agreed, YYYY-MM-DD should be normal use
So its possible to properly sort by date?
A proper date sort would be YYYYMMDD
deleted by creator
Because in short, it’s alphabetical. It will always be in order by year, then month, then day. Literally like how a clock goes HH:MM:SS it’s the same thing as YY:MM:DD the right side ticks the fastest. It’s in order by hour (year) then minute (month) then second (day). SAME SAME WHY NOT
Because for 99.99% of all situations, you’d already know what year and month it is, so the most readily available piece of information should be the day.
If you already know the year and month why write it. ISO or month day are the two most reasonable. You need to zoom in not give yourself a list of options and then randomly pick one later.
YYYYMMDD for files
DDDD DD for normal use
TBH, Japanese format makes sense when you use it to name files/directories, as sorting by “name” is equivalenti to sorting by “last modified”.
equivalenti
Love typos that force me to read comments with an Italian accent
I’m actually italian, lol, but that was a genuine typo.
Free upvotes for both of you
Until you need to work across centuries. Then it’s eating paste level.
Japan I can get behind but MM/dd/yyyy is just evil, why would you sandwich days between months and years? You monster
I’m an ISO 8601 guy but the MM/DD does make sense in American. We’ll say Oct 20th for a date and then straight translate that to numbers 10/20. It makes more sense than counting in French. Ex. 60, 70, 80, 90
Counting in French is an incredibly low benchmark. Nice try!
Prepare your butthole for the Danish spoken number system, where they express integers in fractions
They should just introduce a new system. Noone likes five halves of twenty for fifty. I guarantee it.
Just indroduce English numbers, the end.
It makes more sense than Monty Python.
The only reason I could see is if you were speaking it. September 18th 2012 for example might sound a bit better than 18 September 2012.