>>>>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement