How to calculate a persons age on 31 Dec every year?

[neelsfer]

I need to determine the age of the persons in my tblcyclistdetai l, as on the 31st December every year. The age of the person will therefore only change once per year on the system, and that's on January 1. It must not change if his birthdate is on any other date and is therefore the maximum age of a person for the year.
form = frmcyclistdetai l
relevant fields = Birthdate; age
table = tblcyclistdetai l

thx
Neels

[nico5038]

Just use dateserial(year (Date()),12,31) to subtract the DayOfBirth from.

Nic;o)

[neelsfer]

thx nico for prompt reply

[neelsfer]

got it right
=Format(DateSer ial(Year(Date() ),12,31)-[Birthdate],'yy')
thx
Nico