Calculate Present Age from Birth Date

There are two distinctly different ways given to calculate age. The first is 
easy to understand and implement, yet may not be accurate to the day on leap 
years. The second is more complex and a little more difficult to understand, 
but it is always accurate to the day.

The statements given are for use on the Program Spec, but both may be adapted
for use with a Mass Update.


Procedure 1

    Birth Date: #1

    Age: <#2: #2 = @INT((@DATE - #1)/365.25)


Procedure 2

    Birth Date: #1

    Age: <#2: #2 = @YEAR(@DATE)-@YEAR(#1) - ((@MONTH(@DATE) < @MONTH(#1)) or
          (@MONTH(@DATE) = @MONTH(#1) AND @DOM(@DATE) < @DOM(#1)))




Application: An insurance company can determine the age of their clients given
only their birth dates.


























Q & A Application Note       Rev. 6/92           #2116     Page 1 of 1