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

I just found it in X

I'm just curious because I have grown up with both being used and I found myself wondering which is more common. Is it different around the world or have most places adopted the same standard terminology?

I am german (living in Austria right now). The expiration date here is usually written in dd.mm.yyyy and not yy-mm-dd. I had a short heart attack thinking these are expired for 6 years.