Sorry Andrew: in my previous answer, I forgot to mention an important remark. Reason why earlier (grin grin) I pretended not to understand your 20070710222201 is twofold.
1. Input: If input like you wrote it, your string would never be recognized, by any spreadsheet application, as a valid date and time string, but only as a plain number. You could easily predict the consequences. On the contrary, "2007-07-10" (with or without addition " 22:22:01") WILL always be recognized and interpreted correctly as date (and time). Like input "07-10" default would (should!!) always correctly be recognized and interpreted as date, "[present year]-07-10". 2. User recognition: If your format was to be shown in the FORMULA bar, a reader would be puzzled because of the obvious "number" value shown there, and would NOT see a direct link between that value and cell representation (e.g. as serial number!) of the matching date. On the contrary, format "yyyy-mm-dd" should ONLY be recognized as date (extended representation) and could never be misinterpreted; it would link that info directly to whatever representation applied in the cell itself. Regards, Jan "Andrew Douglas Pitonyak" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > Jan Sax wrote: >> "Andrew Douglas Pitonyak" <[EMAIL PROTECTED]> schreef in bericht >> news:[EMAIL PROTECTED] >> >>> I would use 20070710222201 >>> >> What DATE might that string represent? >> > July 10, 2007, at 22:22:01.00 > > I use the format so that I can send files around and they will fort using > an ASCII sort. The standard does not require delimiters. > All my files are in the same time zone, but unless you bother to insert > the time zone information, the format YYYY-MM-DD etc... is still useless > unless I know for certain who sent me the file and what time zone they > happen to be in (Yeah, I deal with that and it is annoying. I ask for data > in GMT, but what do I get? Look, the data arrived before it was sent... > <grumble grumble> ) > > This site has some good information on 8601 > > http://en.wikipedia.org/wiki/ISO_8601 > > >>> Do you speak Esperanto? >>> >> No, ISO 8601 (and a couple of foreign languages as well). >> > Based on the strength of your statements, I assumed that I might find you > at one of the Esperanto meetings. >> Regards, >> Jan >> >> >>> Jan Sax wrote: >>> >>>> Sorry, wrong message date at the end, should read 2007-07-04 >>>> >>>> "Jan Sax" <[EMAIL PROTECTED]> schreef in bericht news:... >>>> >>>> >>> I would use 20070710222201 >>> >>> Strongly worded... Do you speak Esperanto? >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > My Book: http://www.hentzenwerke.com/catalog/oome.htm > Info: http://www.pitonyak.org/oo.php > See Also: http://documentation.openoffice.org/HOW_TO/index.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
