Has anyone encountered the situation where the exact age is required for
eligibility?
I am working on something that requires a child's age to be between 9
and 14 on a particular race date. I want to be able to display the age
as of the date of a race. The rules are that
01 9th birthday is on or before race day.
02 15th birthday is after race day, not on race day.
That's easy to handle as an eligible/ineligible switch. What I want to
do is to display the age as an integer number by comparing the race date
with the birth date.I can do it in my head as all of you can, but my
little grey cells are on strike. I just cannot figure out a simple
method of displaying this value using a single formula. Example follows.
Birth Date: 6/11/2000 + Race Date: 6/10/2010 = 9 years old.
Birth Date: 6/10/2000 + Race Date: 6/10/2010 = 10 years old.
Birth Date: 6/09/2000 + Race Date: 6/10/2010 = 10 years old.
Data sources:
Races.Race = Cars.Race -- PK < FK
Drivers.DriverID = Cars.DriverID -- PK < FK
Races.RaceDate
Drivers.DriverBirthDate
Age goes here: Cars.Age
The same driver can race in multiple years and multiple races within a
year. The Cars table will list the car and driver in a separate data row
for each race. The age on the specific date of the race is the necessary
integer value
All help gratefully received.
Albert
