OOP was Re: SC - Happy New Year (OT)
Jeff Gedney
JGedney at dictaphone.com
Mon Jan 10 07:27:03 PST 2000
Margali, my dear,
I think the point is that there was a problem in the programming of
dates in earlier versions of EXCEL (and this is a common Y2K
bug) that did nto take into account that the Current calendar is set
up that the century years are NOT leap years, but that Milennial
years ARE. This is to take into account the fact that the year is
Slightly MORE than 365 1/4 years long, and if the Leap year was
EVERY 4 years without exception, then the calendar would slip
as measured astronomically a little under a day a century.
Most versions of this error take either one or the other of these
exceptions into account, and either do NOT male 2000 a leap
year (most common), or make 1900 a leap year.
A properly calibrated calendar makes centennial years normal, and
millenial years leap years.
( or is that the other way around? )
Damned horology...
Brandu
("Your elbow is soooooo exquisite....")
>>> Marilyn Traber <margali at 99main.com> 01/07 6:23 PM >>>
I thought leap year automatically meant feb 29th, which is why it is
called leap day...
margali
puzzled in canterbury
>>>>>
FWIW, anything excel based "knows" about this exception. I hear turns
of
century don't have the leap day unless they are divisible by 1000 (so
this
correction comes in every millenium). But, like you, I could be
wrong.)
At any rate, when I was creating something this morning and used "fill,
down, series, date" I noted that 02/29/2000 was not left out.
Bonne
============================================================================
To be removed from the SCA-Cooks mailing list, please send a message to
Majordomo at Ansteorra.ORG with the message body of "unsubscribe SCA-Cooks".
============================================================================
============================================================================
To be removed from the SCA-Cooks mailing list, please send a message to
Majordomo at Ansteorra.ORG with the message body of "unsubscribe SCA-Cooks".
============================================================================
More information about the Sca-cooks
mailing list