Draft for review: ISO 8601 date work on IS 29500

Chris Rae Chris.Rae at microsoft.com
Thu Jul 8 23:03:20 CEST 2010

Hi Jirka - wow, well spotted. Thank you very much. I've used my magical date spreadsheet (attached, just in case anyone's interested) to work out what the serial value should have been and it seems like it ought to be -693593. I've updated our master copy of the Amendment.

Many thanks! I must say it's great to have other people start to look at our handiwork after all this time.


-----Original Message-----
From: Jirka Kosek [mailto:jirka at kosek.cz] 
Sent: 08 July 2010 04:22
To: Chris Rae
Cc: e-SC34-WG4 at ecma-international.org; Horton, Gareth
Subject: Re: Draft for review: ISO 8601 date work on IS 29500

Chris Rae wrote:

> We'd really appreciate a deeper review from anyone with subject matter expertise here.

Not being really expert on dates, one thing that catch my attention in 2.5:

"•	In the 1900 date base system, the lower limit is January 1, 0001
00:00:00, which has a serial value of ***-4346018***. The upper-limit is December 31, 9999, 23:59:59, which has a serial value of 2,958,465.9999884. The base date for this date base system is December 30, 1899, which has a serial value of 0."

It seems that serial value wasn't changed -- it is not change tracked.


  Jirka Kosek      e-mail: jirka at kosek.cz      http://xmlguru.cz
       Professional XML consulting and training services
  DocBook customization, custom XSLT/XSL-FO document processing
 OASIS DocBook TC member, W3C Invited Expert, ISO JTC1/SC34 member

-------------- next part --------------
A non-text attachment was scrubbed...
Name: date serial numbers.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 33793 bytes
Desc: date serial numbers.xlsx
URL: <http://mailman.vse.cz/pipermail/sc34wg4/attachments/20100708/6293a345/attachment-0001.bin>

More information about the sc34wg4 mailing list