When is a date not a date?

On November 25, 2004, in Sharepoint, by

For those of you in the world that are not MM/DD/YY but backwards [well to me anyway], you do know that Company web has it’s “own“ date settings, don’t you?

Thanks to Kevin for posting this

Check out http://companyweb, Site Settings, Go to Site Administration link,
Change regional settings link.

> Site Settings
> “Go to Site Administration”
> Management and Statistics
> “Change regional settings”.


5 Responses to When is a date not a date?

  1. backrowbloke says:

    Yes, but what about those who have multi-national organisations and need both date formats?

  2. Susan says:

    Set up a second Sharepoint site.

  3. Tintin says:

    The ISO Date format is yyyy-mm-dd.

    This makes sense as well from a database POV, as you can easily sort text in that format correctly. ie






    you can’t sort that if it’s mm-dd-yyyy

    Also, it’s how time is used worldwide (13:23:34.43 — largest unit to smallest, left to right) so it’s already a standard.

    And it’s from importance… a day by itself is close to useless… and a month by itself isn’t a lot of use… but if you only have year, it’s useful…

    so, while I’m busy converting the world… now you can all rest in knowing that my world-date domination has some logic behind it.

    Incidentally, I’m from the UK, and they use dd/mm/yyyy which really is more backwards than the US way… from least to most important… it’s like they’re hebrew or something.

  4. stoo says:

    Cheers, I just spent ages trying to changethe date format for hours!!

    Anyway, I agree with Tintin… lets all go yyyy-mm-dd-hh-mm-ss … so much easier 😛

  5. Jim Kelly says:

    Excellent post Tintin.

    Let’s all actively *stop* using date formats that are ambiguous. During the first ~half of a month it is impossible to tell the date accurately from the common formats of:



    Even worse if you use a two digit year! EG 02-03-04

    I’m all for yyyy-mm-dd and whenever I am forced to use an ambiguous format I spell the month (at least three characters anyway).


    Jim Kelly