At my job I have to use this “SAP” software and I think it’s the worst professional software I’ve ever used. The dates export as three pairs of two digits. No indication of what’s what. The numbers export with commas, so like “1234” comes out in the csv as “1,234”. I hate it. It also mangles some other data so like “0000” turns into “” for some reason.
Isn’t the year always at the end anyway?
YYYY-MM-DD is the best format, please don’t change my mind :)
This one sorts correctly in the computer.
I prefer 31JAN2026 myself. No ambiguity, readable internationally.
Doesn’t sort well on file systems, where it is usually best to sort first by year, then month and day.
Internationally where English is understood
I love a good, lexically sortable date format.
yes, good for structuring your file folders too
…/documents/2026/01/15/ and …/documents/2026/01/16/ is not only easier to read but also navigate
Nope, some absolute madlads use
YY/MM/DD
Which was really fun when you get something like 12/03/11
I propose YM/DM/YD
At my job I have to use this “SAP” software and I think it’s the worst professional software I’ve ever used. The dates export as three pairs of two digits. No indication of what’s what. The numbers export with commas, so like “1234” comes out in the csv as “1,234”. I hate it. It also mangles some other data so like “0000” turns into “” for some reason.
Oh wow. How is that not workflow destroyingly bad? Hopefully it doesn’t generate filenames with that format
It is! I spent a lot of time manually cleaning up the CSV, and there were still problems.
Apparently there’s some other way to export data that’s not horrible but I’m not authorized to use it for some reason.
I work at a big company with very weak testing culture.
I always do it at the start. So I can sort by name. And it will be sorted by date
Not only that, it goes in order of importance
It’s more important to know that something happened in 2026 than what month
It’s more important to know that it happened in January than which particular day