For play.
To go forward or backward with months are not the same thing.
For next case, is correct young,old or both??
IF GOMONTH({^1998/02/28},-18*12)>= {^1980/02/29}
? 'old'
ELSE
? 'young'
ENDIF
IF {^1998/02/28}>= GOMONTH({^1980/02/29},18*12)
? 'old'
ELSE
? 'young'
ENDIF
Fabio
>IF GOMONTH(DATE(),-18*12)>= DateOfBirth the person is older than 18.
>
>>Hi
>>I am trying to create a function in either VFP8 or transact-SQL which will accurately determine if someone is 18 years old or more.
>>
>>I have had a few stabs at it, but I'm sure I've seen functions in the past that have done this.
>>
>>Does anyone know of such code or can point me at a back issue of FPA etc.?
>>
>>TIA,
>>Simon