Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go »
No member browsing this thread
Thread Status: Locked
Total posts in this thread: 16
Posts: 16   Pages: 2   [ 1 2 | Next Page ]
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 4434 times and has 15 replies Next Thread
johann.petrak
Cruncher
Joined: Nov 8, 2005
Post Count: 6
Status: Offline
Project Badges:
sad Please use a proper date format (ISO)

It is really absurd and annoying that a global project forces everyone to use/put up with the absurd, non standard date format MM/DD/YY that no one every uses outside of the US and not many use in the US when they are doing proper research and can avoid it.

At least make it configurable.

E.g on https://www.worldcommunitygrid.org/team/viewT...=name&teamId=XXXXXXXX

or on

https://www.worldcommunitygrid.org/stat/viewMemberInfo.do?userName=xxxxx
[Sep 23, 2021 6:31:12 PM]   Link   Report threatening or abusive post: please login first  Go to top 
PMH_UK
Veteran Cruncher
UK
Joined: Apr 26, 2007
Post Count: 786
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

+1
This has been requested before.
Some pages obey format set in locale, some don't and some have mixed format on the same page!
Old ones include "Member since", "last updated" on team page, "installed & registered" on device management.
Many new pages show local date such as yyyy-mm-dd but "created" on results page is mmm. dd, yyyy as popup on overview page, My activity over time and "last result returned" is monthname dd, yyyy

Paul.
----------------------------------------
Paul.
[Sep 23, 2021 7:26:04 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Sgt.Joe
Ace Cruncher
USA
Joined: Jul 4, 2006
Post Count: 7844
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

It is really absurd and annoying that a global project forces everyone to use/put up with the absurd, non standard date format MM/DD/YY that no one every uses outside of the US and not many use in the US when they are doing proper research and can avoid it.
At least make it configurable.

I do a bit of spreadsheet work and in the course of that run across differing date formats. All of the spreadsheet types I use (Excel, Gnumeric, and LibreOffice Calc) are pretty adept at converting the existing format to one which may be more acceptable in various applications. Any of the statistical packages such as SAS, SPSS, etc handle a variety of date/time formats.Even if the date is formatted as text rather than as a date, it can be handled.
In some posts I did several years years ago, this issue was brought to my attention as I was using the mm/dd/yy format. I changed to the alpha for for the month and went with the 4 digit year. This eliminated any confusion as to what date was referenced i.e January 01, 2021.
As to how the dates appear on the website, that is up to the web designers. I can get used to just about any format as long as I know which one is being used.
Cheers
----------------------------------------
Sgt. Joe
*Minnesota Crunchers*
[Sep 23, 2021 7:31:38 PM]   Link   Report threatening or abusive post: please login first  Go to top 
johann.petrak
Cruncher
Joined: Nov 8, 2005
Post Count: 6
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)


I do a bit of spreadsheet work and in the course of that run across differing date formats. All of the spreadsheet types I use (Excel, Gnumeric, and LibreOffice Calc) are pretty adept at converting the existing format to one which may be more acceptable in various applications.

No spreadsheet, nor any human will / can possibly know if 02/01/2021 refers to Feb 1st or Jan 2nd without context or knowledge whether the utterly idiotic US format MM/DD/YYYY is used or the less idiotic but still stupid non ISO format DD/MM/YYY.
It is absurd that in 2021 on a "scientific" web page one has to even think about this.

The date should be shown in format YYYY-MM-DD everywhere as is common in practically all parts of the world and especially among scientists so no human or excel sheet or other software needs to second guess which format may be used. This is why ISO exists and has been a success.

Yes it is up to the web designer or rather implementer and I have posted this under "Website support" exactly for the reason that the implementer has got it embarrassingly wrong on many pages, hopen for somebody to finally correct it.
[Sep 23, 2021 10:42:33 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Sgt.Joe
Ace Cruncher
USA
Joined: Jul 4, 2006
Post Count: 7844
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

No spreadsheet, nor any human will / can possibly know if 02/01/2021 refers to Feb 1st or Jan 2nd without context or knowledge whether the utterly idiotic US format MM/DD/YYYY is used or the less idiotic but still stupid non ISO format DD/MM/YYY.

Yes, context is the key. Interesting, I did not know there is a format which used a 3 digit year. I am also thankful they are not using a Julian date format. smile
Cheers
----------------------------------------
Sgt. Joe
*Minnesota Crunchers*
[Sep 24, 2021 1:23:48 AM]   Link   Report threatening or abusive post: please login first  Go to top 
BobbyB
Veteran Cruncher
Canada
Joined: Apr 25, 2020
Post Count: 638
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

Where I am (french Canada), DD/MM/YYYY is generally used whereas english Canada generally uses MM/DD/YYYY.

My question: why is DD/MM/YYYY less idiotic than MM/DD/YYYY. smile
I understand the stupid part re:02/01/2021. quoi?
[Sep 24, 2021 4:03:23 PM]   Link   Report threatening or abusive post: please login first  Go to top 
D_S_Spence
Advanced Cruncher
Canada
Joined: Jan 5, 2017
Post Count: 118
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

YYYY-MM-DD is big-endian and is perfect.
DD-MM-YYYY is little endian for the date portion, but then the time that follows is always big-endian (HH:mm:SS).
MM-DD-YYYY is some kind of weird middle-endian monster. It hurts my brain. :-)
[Sep 24, 2021 4:38:58 PM]   Link   Report threatening or abusive post: please login first  Go to top 
BobbyB
Veteran Cruncher
Canada
Joined: Apr 25, 2020
Post Count: 638
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

That explains nothing relating to my question. The ISO version is the sorting order and is perfect except when speaking.

The other two are just the way it is spoken.and are equally idiotic but only for this conversation because one was deemed less idiotic than the other.

Aujourd'hui est le 24 septembre 2021
Today is September 24 2021

No one says:
Today is 2021 September 24 or
Aujourd'hui est le 2021 septembre 24

Well maybe R2D2 on a bad day
[Sep 24, 2021 9:13:26 PM]   Link   Report threatening or abusive post: please login first  Go to top 
adriverhoef
Master Cruncher
The Netherlands
Joined: Apr 3, 2009
Post Count: 2346
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

My question: why is DD/MM/YYYY less idiotic than MM/DD/YYYY. smile

Maybe because there's a simple answer: mm/dd/yyyy is idiotic, where dd/mm/yyyy isn't laughing;
dd/mm/yyyy (or dd-mm-yyyy or dd.mm.yyyy or dd mm yyyy) is more logical.

Nearly every country in the world uses some form of DMY or YMD, except American Samoa, Federated States of Micronesia, Guam, Marshall Islands, Northern Mariana Islands, United States Minor Outlying Islands, United States Virgin Islands.
Nearly all countries don't use MDY (Australia uses MDY sometimes, Eritrea sometimes, Guinea sometimes, Hong Kong rarely, India sometimes, Nepal sometimes, Norway rarely, Palau rarely, Singapore sometimes, Sri Lanka rarely, United Kingdom rarely, Vietnam sometimes).
(See Wikipedia.)
[Sep 25, 2021 9:56:20 AM]   Link   Report threatening or abusive post: please login first  Go to top 
BobbyB
Veteran Cruncher
Canada
Joined: Apr 25, 2020
Post Count: 638
Status: Offline
Project Badges:
Re: Please use a proper date format (ISO)

That is still just an opinion (yours) that DMY is more logical probably because where you are uses it and that is what you are used to seeing. My neighbours to the south would probably see it completely the opposite.

Like I said, both are used where I am. MDY and DMY regardless of what Wikipedia says. I'm talking of the people on the street.

Both are illogical in writing especially in the first 12 days of any month.
----------------------------------------
[Edit 1 times, last edit by BobbyB at Sep 25, 2021 3:24:13 PM]
[Sep 25, 2021 3:16:09 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Posts: 16   Pages: 2   [ 1 2 | Next Page ]
[ Jump to Last Post ]
Post new Thread