Hiya Mike,
Try:
floor((date() - d_Birth)/365.25)
The value 365.25 accounts for leap years.
>greetings to all
>
>i need the code for calculating the age as follows:
>i habe a field where we input the date.
>i need to calculate the age on another field based on the current date
>
>any ideas?
>
>regards
>mike peizate
kenweber
GCom2 Solutions
Microsoft Certified Professional