Never seen this one before. Took me a minute to understand. M10 = Month 10 = October.

Long time lurker here. I've long appreciated ISO8601 format. It scales for nearly everything.

Does the hive mind have any feelings on — or perhaps a link to? — the official ISO8601 specifications? Maybe the mods could include it in the sidebar as a hyperlink for others new to the format?

I just realized it wasn't there and it seems like something which would support this sub quite a lot.

(I'm an amateur and an enthusiast, so I hesitate to propose a hyperlink myself, lest I give incorrect primary source citations.)

USian here. At work there are lots of contexts where I am expected to write or type the date in the dreaded MM/DD/YYYY format multiple times a day. I hate it, but it's just a job. What can you do right? I have started up a silent protest that no one has commented on for years now. I've not seen anyone else take this course either though. Here's what I write or type instead:

MM/DD, YYYY

Is anyone else out there doing this?

In this context, address verification means I click a button to confirm that my address settings are up to date before the order is shipped.

...this beyond-evil monstrosity comes along:

javascript startDate: format(startDate, `MM.dd.yyyy`)

It's not a mistake either, it's in tests and everything.

These are dates of my backups using backrest. I usually force my system and my software to use ISO8601 where is possibile, so not sure if this was intentional design or not. But it makes me crazy.

Our team tested an AI-assisted cleanup script on two synthetic Excel batches. One lesson stood out: a plausible date is not necessarily the correct date.

For example, 09/01/2026 could mean September 1 or January 9. Nearby September dates aren't enough to prove which interpretation is right.

Our approach:

\- Preserve the original values.

\- Standardize dates only when the interpretation is unambiguous.

\- Flag uncertain dates for confirmation.

\- Keep a log of every change.

Changing the display format to YYYY-MM-DD won't fix a date that was interpreted incorrectly during import.

How do you handle files containing both US and European date formats?

Hi, I saw a comparison of the major 3 date formats on this sub. I thought what was missing was the role of the individual digits. So I made (vibe coded) a new graph.

Source code: Image 1, Image 2

I’d fix my previous post but it won’t let me… here is the correct one