[thelist] Date formatting woes ...
Vlad Alexander (XStandard)
vlad.alexander at xstandard.com
Fri Oct 15 11:47:17 CDT 2004
Hi Rob,
Use the ISO8601 date format. It looks like this:
YYYY-MM-DDTHH:MM:SS
The added bonus is that this format can be sorted using a text sort algorithm.
We have a free COM component that can be used to convert to and from this date format:
http://xstandard.com/page.asp?p=B211ECB4-8403-424F-B781-1BC6021E351B
Regards,
-Vlad
http://xstandard.com
Standards-compliant XHTML WYSIWYG editor
----- Original Message -----
From: "Rob Smith" <rob.smith at THERMON.com>
To: "Thelist (E-mail)" <thelist at lists.evolt.org>
Sent: Friday, October 15, 2004 11:47 AM
Subject: [thelist] Date formatting woes ...
> Hi,
>
> I've built this cool web app for my company that keeps track of all the
> things we do around here and while it works beautifully, there has been some
> concern raised with date formatting. The server is here the US of A, but at
> the same time, we have employees all over the world using it.
>
> The server timestamps stuff with the MM/DD/YYYY HH:MM:SS format because it's
> configured for America's time format. We have our guys and gals in Europe
> who're doing 21 September 2004 and the guys and gals in the US doing
> 9/21/04.
>
> One of the things I was pondering was that I detect the user's location and
> flip a toggle switch to where ever there is a date coming out of the server,
> it flips it over the to the Europe standard. Visa Versa for the US folks.
>
> My brain is a little fried this morning, can you offer some strategies in
> your multi-national experience and finding a norm that's not confusing?
>
> One of the known pieces of this puzzle is that this is a US based company.
> The tendency is to lean towards sticking with the US time standards and let
> the folks out in the EU enter dates in the US format for this project only.
>
> I'm writing a users manual for this web app and we have to write something
> down,
>
> Rob Smith
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list