formula for age betwwen two dates

[deeya]

CR7 Oracle

What i want to do is findout a students age between two dates in the past i.e [term startdate] and [term enddate].

Once the age is established between those dates I want to find at age 14-15 what school they were at alongside teher current school.

Many thanks

 

[lbass]

Please see:

http://www.kenhamady.com/form06.shtml

I think you need to use separate formulas for term startdate and term enddate, as the birthday could occur within the range, resulting in two valid ages for the period. Substitute the date fields for the variable "ann".

-LB