Forum Moderators: open

Message Too Old, No Replies

What Date Format do YOU use on YOUR website?

         

g1smd

7:39 pm on Jul 3, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Are you a 07-03-02 or 03-07-02 person, or does 03 July '02 or July 03, '02 do it for you?

Have a look at:

[dmoz.org...]

and

[w3.org...]

before replying.

[edited by: engine at 7:53 pm (utc) on May 11, 2005]
[edit reason] trailing slash added [/edit]

austtr

6:14 am on Jul 10, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



aahh..!! an old favourite has surfaced yet again.

I'm with rewboss all the way on this one. If the page we present to the world is intended to be read, understood and used by PEOPLE from all nationalities and levels of education/intelligence/age groups, then we have an obligation to make that page absolutely free from misunderstanding... and standards be damned!

If I design a site for a holiday resort and the booking form allows arrival and departure dates to be interpreted differently, think of how much sh*t will hit the fan when the customer thinks they are booking for 7th March and the resort makes the booking for 3rd July.... a lawyers smorgasboard!

Don't assume dates will be read the same way by everyone... I can assure you absolutely they will not.

Purple Martin

8:08 am on Jul 10, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The post before this one was made at "4:14 pm on July 10, 2002 (EST +10)", that includes my local settings of course.

Yes I can easily understand the exact time and date.
And it's not in ISO 8601 format.

So is WW's official policy to ignore international standards? Tell us, tedster and/or papabaer, this is a direct question to you guys!

rewboss

10:15 am on Jul 10, 2002 (gmt 0)

10+ Year Member



:: pinching himself ::

ISO 8601 is not understood by Mr and Ms Average-Surfer.

ISO 8601 may be used in technical documents. Maybe the military use it as well. These are specialist fields and Mr and Ms Average-Surfer -- the people I am designing my sites for, for the most part do not understand ISO 8601.

As for the international issue...

If I write a page in English, I will write the date as 10th July 2002, and the time as 11.45am. The chances are that anyone who doesn't understand that format won't understand the rest of the page and won't be reading it.

If I write a page in German, I will write the date as 10. Juli 2002, and the time as 11:45 Uhr. Wahrscheinlich werden diejenigen, die dieses Format nicht verstehen, den Rest der Seite auch nicht verstehen und auch nicht lesen.

If I write a page in Russian, I will write the date as 10 iul' 2002, and the time as 11:45 ch. Yesli ne ponimayut... uh, well I think you get the point.

If you want my site to be accessible to everybody no matter what their native language, what must I do to achieve this? Following this line of logic, we must have no text at all on any of our websites.

You cannot force the issue. People will use what they are used to, and that's that.

Did you know that the USA adopted the metric system for its weights and measures as the only legal standard? But you won't find many people using it because their great-great-gandparents used (actually misused) the First Amendment to assert their right to use whichever standard they wanted, and they wanted the old system.

In Britain, bus and train timetables are written in 24-hour format. But you will usually find a little diagram somewhere explaining how the 24-hour format works, because few Brits use the 24-hour clock for anything except bus and train timetables.

Just because a standard exists doesn't mean it is always sensible to use it; certainly not without thinking through the consequences.

We try our best to stick to the W3C recommendations for markup because, in theory at least, it makes our sites faster, more likely to be cross-browser compatible and also (if the software giants play fair) forwards compatible. But markup isn't for Mr and Ms Average-Surfer, it's for Mr and Ms Web-Designer, Internet Explorer and friends.

jgbptl

10:19 am on Jul 10, 2002 (gmt 0)



I am all for the YYYY-MM-DD format, and that is not just because I happen to live in a country where it is in general use. A couple of years ago I worked for an international organization, my co-workers coming from 17 different countries and using all known Gregorian date formats. What I found was that although most of them never had heard of ISO 8601 or YYYY-MM-DD formats no one ever misunderstood a date in YYYY-MM-DD format. Some had to stop and think a little, but they all understood it without any explanation from me.

That said many of my co-workers still preferred the format they had grown up with, even though it was undisputable that it was more likely to cause misunderstandings then YYYY-MM-DD. The arguments were often in line with "It reflects the natural way humans think." But when three people all (at the same time) claimed that their own different way of writing dates represented "the natural way humans think" it became quite obvious to everyone that there is no such way but merely what one is used to.

Therefore, when designing software I use the locale settings of the operating system when displaying (and accepting) dates, but when it comes to web-pages and printed documentation it will always be in YYYY-MM-DD. I motivate that with it being better to use a format that some people will have to stop and think a little about but no one will misunderstand then a format that some will get right immediately but others will misunderstand. It being an international standard is of course an extra plus.

rewboss

8:36 am on Jul 11, 2002 (gmt 0)

10+ Year Member



What I found was that although most of them never had heard of ISO 8601 or YYYY-MM-DD formats no one ever misunderstood a date in YYYY-MM-DD format. Some had to stop and think a little, but they all understood it without any explanation from me.

The point is that a date such as 11 July 2002 is instantly understood by anyone who speaks English (and a large number of people who don't), and is completely unambiguous.

There are so many other things that we could standardize. Here are some examples:

Weights and measures: The metric system is used in most countries in the world. It is also the official system in the only major country that doesn't regularly use it. There is therefore no reason to use inches, pounds, miles etc on the web. Goodbye 17" monitors, hello 43cm monitors.

Numerical notation: Decimal points and thousands separators vary wildly from country to country. In deference to the fact that the International System of weights and measures, used by scientists, was developed in France, we should use the French system: commas as decimal points, and periods to separate the thousands.

Mathematical notation: The divide-by symbol also varies from country to country. Since slashes are used to approximate vulgar fractions, we should adopt the colon, as used in many European countries.

Paper format: A constant source of problems is the issue of paper format, which also varies from country to country. In order to ensure that a document written in Europe will fit on an American standard letter (or vice versa), it must be reduced to about 92% original size. Since the German Industrial Norm (DIN) has proved so successful and been adopted by all European countries, this should be the format used. An interim transitional period should be granted to allow Americans to replace or reconfigure their printers and photocopiers.

Postal addresses: There are many anomolies here. For instance, the German Post insists that, on overseas letters, the country should be on the last line of the letter and the only line written in block capitals; the British Post Office, however, insists that the town or city name be written in block capitals and the post code to be the last item, even on mail coming from abroad. Postal addresses badly need to be standardized. (This will also help webmasters design forms for shipping information.) French is the official language of the International Postal Union, so country names should be written in French.

victor

9:23 am on Jul 11, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The object of the exercise, I guess, is to communicate clearly and unambiguously with your audience.

Clearly a date of 1/2/3 will work clearly and unambiguously only if you are absolutely sure the person reading it understands your conventions.

On the other hand, 2001-02-03 is only probably unambiguous and may cause some head-scratching before the reader twigs -- so it is not 100% clear either.

Both those "other hand" problems due to the (as yet) non-universal acceptance of ISO8601.

I suggest the answer (given we are in a transitional period) is to use ISO8601 and (if your site/audience) need it, a local format too:

2001-02-03 (3rd Mar) would cover a lot of the cases I use.

jgbptl

12:57 pm on Jul 11, 2002 (gmt 0)



Yes, rewboss, I agree with you that 11 July 2002 is instantly understood by anyone who speaks English (although I assume that the Americans would prefer July 11, 2002) and I actually use it where it is appropriate.

However, there is also a need for a strictly numerical date format in many web-applications.

One example would be applications where visitors might modify or enter date. Yes, it can be solved with three drop down lists: 1-31, January-December and years, but this type of interface tends to be a bit annoying when there are many dates to enter.

Another would be large lists of events, say financial transactions, where you are interested in the distance (time wise) between them. Although everyone would understand 11 March 2002 and 9 August 2002 most people will count on their fingers to find out how many months there are between them. A strictly numerical format is more appropriate in that case.

A third example is when other parts of the web-application are using a numerical format of one reason or another (maybe one of the two above). Then it can be a good idea to use the numerical format even where you otherwise might have used "11 June 2002" since consistency also is important.

Anyway, my point is not really the examples as such, but merely that sometimes a strict numerical date format might be desirable.

On a side note: Some years ago I developed a software for international mailing lists (snail mail that is) and got very frustrated trying to support all the different address formats, especially the UK one. As you pointed out, most of the time it is impossible to adhere to both the originating country’s address standard and the UK one at the same time.

pageoneresults

12:10 am on Jul 12, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Okay, I got way too entrenched in this date and time thing. So much so, we had to write a custom script to generate the date format in .asp. For those who are using asp and looking for a date formatting script, try this one...

Variable - Current Date and Time
<%=lastrevisedn%>

<%
'*** date now
lastrevised = now
lrtime = formatdatetime(lastrevised,vbshorttime)
edward = formatdatetime(lastrevised,vblongtime)
edward = left(edward,len(edward)-3)
arredward = split(edward,":")
edwardfoo = arredward(2)
lrdate = formatdatetime(lastrevised,vbshortdate)
arrdate = split(lrdate,"/")
if arrdate(0)<10 then arrdate(0) = "0" & arrdate(0)
if arrdate(1)<10 then arrdate(1) = "0" & arrdate(1)
lrdate = arrdate(2) & "-" & arrdate(0) & "-" & arrdate(1)
lastrevisedn = lrdate & " " & lrtime & ":" & edwardfoo & " " & "UTC"
%>

Variable - Last Revised Date
<%=lastrevisedt%>

<%
'*** date then
lastrevised = rstemp("lastrevised")
lrtime = formatdatetime(lastrevised,vbshorttime)
edward = formatdatetime(lastrevised,vblongtime)
edward = left(edward,len(edward)-3)
arredward = split(edward,":")
edwardfoo = arredward(2)
lrdate = formatdatetime(lastrevised,vbshortdate)
arrdate = split(lrdate,"/")
if arrdate(0)<10 then arrdate(0) = "0" & arrdate(0)
if arrdate(1)<10 then arrdate(1) = "0" & arrdate(1)
lrdate = arrDate(2) & "-" & arrdate(0) & "-" & arrdate(1)
lastrevisedt = lrdate & " " & lrtime & ":" & edwardfoo & " " & "UTC"
%>

You may want to change the naming structure, that's my programmer being funny. His response; "Do you have to have milliseconds?" My response; "Yes, I have to have milliseconds!"

The current date and time is...

2002-07-11 17:11:19 UTC

g1smd

1:56 am on Jul 12, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Jeez. What did I start? Thanks for the program code. Niice.

Your programmer may also be interested in:

[exit109.com...]

[delphi32.com...]

[cs.tut.fi...]

[pvv.org...]

[personal.ecu.edu...]

[phys.uu.nl...]

[cs.waikato.ac.nz...]

[merlyn.demon.co.uk...]

[cpearson.com...]

[whizkidtech.net...]

I think that is all of the ones with program code in them.

I got your mail. Haven't had time to deal with it. Give me a few days (at least).

pageoneresults

5:21 pm on Jul 12, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Here is the FrontPage webbot code one more time for those who may have missed it...

<!--webbot bot="Timestamp" S-Type="EDITED" S-Format="%Y-%m-%d %H:%M:%S UTC%Z" -->

Produces this...

2002-07-03 19:03:05 UTC-0700

<!--webbot bot="Timestamp" S-Type="EDITED" S-Format="%Y-%m-%d %H:%M:%S UTC" -->

Produces this...

2002-07-03 19:03:05 UTC

BTW, Standard time zone is UTC-0800 hours here in Sunny Southern California. Due to daylight saving time adjustment of +1 hour, the current time zone offset is UTC-0700 hours.

UTC means Universal Time, Coordinated or Coordinated Universal Time.

P.S. If you need a double space between date and time, just add two non-breaking back spaces between these two (%d&nbsp;&nbsp;%H)

rewboss

6:42 pm on Jul 12, 2002 (gmt 0)

10+ Year Member



pageoneresults' dates are not in the ISO format. ISO says no spaces are allowed, and the time zone must be given in hours and minutes (abbreviations for time zones are not universally understood -- e.g. Germany is on CET or MEZ, depending on whether your native language is English or German).

2002-07-03 19:03:05 UTC-0700 should be:
2002-07-03T19:03:05-07:00 or:
20020703190305-07

One example would be applications where visitors might modify or enter date. Yes, it can be solved with three drop down lists: 1-31, January-December and years, but this type of interface tends to be a bit annoying when there are many dates to enter

On the other hand, using text input fields increases the likelihood of erroneous entries due to carelessness or misunderstood instructions. You will need to validate the form very carefully indeed -- for example, should slashes be acceptable alternatives to hyphens to separate year, month and date? How do you handle a case where a user doesn't understand the need to include a leading zero? If there are "many dates to enter", why would this be so? Does your form really need to be that complex?

Another would be large lists of events, say financial transactions, where you are interested in the distance (time wise) between them. Although everyone would understand 11 March 2002 and 9 August 2002 most people will count on their fingers to find out how many months there are between them. A strictly numerical format is more appropriate in that case.

You would probably use a nifty script to do those calculations anyhow. If you are operating within a narrow specialist field where there is an agreed numerical format which everyone uses as a matter of course, that's fine. It's the same with currencies: wherever possible, on sites to be accessed by the general public, you use $ and € (not always possible, as discussed elsewhere) and £; on sites of interest only to financiers, you use USD, EUR and GBP.

Also, in most everyday cases, people don't think in terms of "first month, second month, third month...", they think "January, February, March..." People booking their holidays will think "Leaving 14th July, coming back 2nd August". If they are then forced to start thinking 7/14 - 8/2 (because they have to enter numerical dates to book their flights), then they start counting on their fingers.

Tapolyai

3:59 am on Jul 13, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Just one more variable - there are several countries where the date is recorded as:

2002 VII. 03. (or without the 0).

Zaccix

9:57 pm on Jul 13, 2002 (gmt 0)

10+ Year Member



"Please don't use GMT, that term went obsolete in 1971."

Strange, we still use that term in the UK.

g1smd, it seems as if, rather than suggesting that we use the ISO standard for dates, you're banging people with a stick and saying "you MUST use this because it's the standard!" As others have pointed out, it may be a standard, but that doesn't mean we have to use it. CSS layout is now considered the "proper" way to lay out a page, but that might not work for all audiences.

Also, not everything the W3C publishes should be taken as gospel. They're not perfect and they do get it wrong sometimes, or rather get it half right but need to work on it some more.

victor

7:35 am on Jul 14, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Tapolyai:
2002 VII. 03. (or without the 0)

I think NATO tried that format for a time. It was a compromise because the Brits and the French couldn't agree the language for the abbreviated 3-letter month names. It never caught on as a standard.

Zaccix:
....it may be a standard, but that doesn't mean we have to use it.....might not work for all audiences.

I think you've hit the key points here. There are undoubtable many websites whose users would benefit from the ISO standard date format -- almost anything with an international audience for example.

But there are many today which probably would not. It's good that g1smd has raised this issue -- it gives the concerned webmaster a chance to consider it, and maybe experiment with some changes.

If a few people report back that ISO dates triple their conversions, the whole thing may snowball.

And, even if it doesn't today, it seems reasonable to keep the issue under review -- if a whole generation is growing up using ISO 8601, then the proportion of sites whose users benefit from it will steadily increase. Starting, I'd guess, with the important international youth market.

rewboss

1:21 pm on Jul 14, 2002 (gmt 0)

10+ Year Member



"Please don't use GMT, that term went obsolete in 1971."
Strange, we still use that term in the UK.

That's because the British are pathetically proud of the fact that it is Greenwich Mean Time, Greenwich being in London. This upset the French (the French and the British have been traditional rivals for 1,000 years), so UTC is now the politically correct (and official) form.

Tapolyai:
2002 VII. 03. (or without the 0)
I think NATO tried that format for a time. It was a compromise because the Brits and the French couldn't agree the language for the abbreviated 3-letter month names. It never caught on as a standard.
I think Russia uses Roman numerals for months; rather odd, seeing as the Cyrillic alphabet doesn't have either a V or an I.

But it didn't catch on in Britain and France, and this illustrates the problem: it's very difficult to force people to use a standard they are unfamiliar with.

For ISO8601 to be readily accepted by all would require that all countries in the world enact legislation to this end. Most countries simply won't bother. Many European countries will probably accept it grudgingly, but it will take several generations. Americans will most likely simply refuse, and will do what they did with metric weights and measures: invoke the First Amendment and claim it means they can express their dates in whatever form they choose.

Even if we could get all governments to co-operate, I estimate it would take another 40 years to implement.

Since this discussion has started, and especially since I have been more or less told that YYYY-MM-DD is practically taking over the world, I have kept my eyes peeled for any evidence. I have not seen a single incidence of this format being used anywhere at all, except for a few I have been specifically pointed to in this thread.

This 86 message thread spans 6 pages: 86