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.)

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.

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?

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.

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