>>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
>
>Hi Mike,
>
>...and one more for you:
>lnyears = YEAR(DATE()) - YEAR(ldDateofBirth)
>IF GOMONTH(ldDateofBirth, lnyears * 12) > DATE()
> lnyears = lnyears - 1
>ENDIF
How about an FAQ entry guys? This one comes up all the time.
Erik Moore
Clientelligence