RB Smissaert wrote:
I am dealing with a clinical (patients) database and there are only 8
patients with a date of birth before 1900-02-28, so not a major problem.
Clinical data is all well after that. I will see what the speed penalty is
from doing the when then else and if it is small then apply it to the date
of birth only. Thanks again for getting me on the right track.
Bart,
You might want to check the records for the patients with DOB before
1900-01-01, since these dates can't be expressed as excel date serial
numbers (the lowest valid value is 1 or 1900-01-01). Note, that julian
day numbers can express dates back to 4700 BC, but Excel can't.
The testing needed to fix the dates for excel's bug only applies to
dates in the first two month of the year 1900, so it can probably be
safely skipped.
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
