Hi Ken,

Try born on February 28, 1979.

Age on February 28, 1980: 0
Age on February 28, 1981: 2
Age on February 28, 1982: 3
Age on February 28, 1983: 4
Age on February 28, 1984: 4
Age on February 28, 1985: 6

The problem is that some date ranges will have more than (# years/4) leap years and some will have less...

Joe

>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