RE: [office-formula] Conflict between Part 1 and Part 2

[Eric Patterson <ericpa@exchange.microsoft.com>]

On February 08, 2010 2:25 PM, " Andreas Guelzow [mailto:andreas.guelzow@concordia.ab.ca]"; wrote:

>If we require that all dates from 1899-31-1 onwards shall be
>supported, then an implementation with nulldate 1903-12-31 will be
>required to support negative dates.
>
>I am abut surprised about you mentioning of 24:00 since that would be
>at the end of the day. Did you mean 0:00?

You are correct, I misread the original statement.  What I mean to convey though is that by supporting a specific null-date, an application is equating zero to midnight (24:00) on the null-date.  Any serial number > zero will produce a date/time that comes after the null-date.


-Eric