Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accurately calculating a persons age
Message
From
22/10/2004 13:28:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00953701
Message ID:
00953799
Views:
8
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform