New Rant Thread

[R181]

MM/DD/YYYY seems normal, today is Feb 28, 2025, I don't like the other way.

The rest of the world doesn't and if you are in Canada, you get both thrown at you which really can make things difficult.

Bob

 

[Chris]

MM/DD/YYYY seems normal, today is Feb 28, 2025, I don't like the other way.

Yet you celebrate independence day on the 4th of July.

 

[chazt]

I was raised on the American format, but have no problem with the more world-centric method. Having spent some time here the last few years, I’ve even started using it occasionally; it eliminates the need for “th” following the date. Kind of makes sense.

 

[p.b]

I've just spent an hour trying to get Excel to highlight dates that fall within the next 30 days in a different colour. No matter what I do with the settings it changes dates to MM/DD/YYYY and will not accept DD/MM/YYYY. You know, the format used by THE ENTIRE PLANET apart from Americans. Microsoft sucks.

Change it to DD-Mon-YY in the format. That always works for me.

 

[SpeedyPC]

Aussie always follows DD/MM/YYYY.... BUT!!

When I used to work for an engineering corporation, I do it YYYY/MM/DD - Job Number

 

[Chris]

Aussie always follows DD/MM/YYYY.... BUT!!

When I used to work for an engineering corporation, I do it YYYY/MM/DD - Job Number

YYYY/MM/DD is the ISO standard I believe, it has the advantage that you can sort it numerically and get chronological order.

 

[Vacumatic]

YYYY/MM/DD is the ISO standard I believe, it has the advantage that you can sort it numerically and get chronological order.

That is how records are stored on the Police National Computer for the reason you suggest, not easy to read automatically however.

 

[R181]

YYYY/MM/DD is the ISO standard I believe, it has the advantage that you can sort it numerically and get chronological order.

Thanks for the explanation. That makes sense because you are looking to locate a certain job number. However, when trying to match visa receipts to the right date on a monthly visa statement it can be a bit tricky when you have 2 dating formats in use by different vendors.

Bob

 

[TobyC]

Yet you celebrate independence day on the 4th of July.

 

[Tonyschin]

We had bigger fish to fry.

 

[Twelvefret]

Yet you celebrate independence day on the 4th of July.

Just remember, you opened the door.

 

[slapo]

YYYY/MM/DD is the ISO standard I believe, it has the advantage that you can sort it numerically and get chronological order.

The ISO date format is usually YYYY-MM-DD.
Probably so dates are easier to sort as strings that way.
Has @p.b's suggestion helped?

 

[SpeedyPC]

YYYY/MM/DD is the ISO standard I believe, it has the advantage that you can sort it numerically and get chronological order.

This got nothing to do with ISO standard, when I first use Windows 3.1 for DOS on the job long time ago. It’s how Microsoft Windows keeps the files in order, and easier to digitally archive and easier to find the data records.

 

[MntnMan62]

We all know how the US does it. The picture was unnecessary. But of course, you already knew that...

 

[TobyC]

We had bigger fish to fry.

You're the ones who got fried, now I see you're kissing the ring.