community.borland.com

Article #25352: How to calculate the age from a date field

Problem:
Looking for example of how to calculate the age of a 
person given by their birthdate in a computed by field.


Solution:
Here is an example:

Assume that table1 contains field d1 with the birthdate information.

alter table table1 add d2 computed by (cast (floor(("TODAY"-d1)/365.25) as integer));

Note: floor is one of the functions that is supplied with the InterBase v5.x UDF library.

Last Modified: 18-OCT-00