>>>>>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.
>>
>>Hmmm ... I figured there was one by now from Vlad or George or one of the guys that has given these equations out so many times.
>>
>>Bill
>
>I just approved another one by Evan Delay. Check "New" :)
>
>Nick
Nick, you can delete mine and incorporate into into a combined one with the others if you want.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only