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