Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is best way to calculate age
Message
From
21/09/2006 11:24:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01155605
Message ID:
01156024
Views:
35
>>>>No problem and I don't care if you use or not. Woould you tell me what do you mean by "since this class returns an incorrect result"?
>>>>Cetin
>>>
>>>
>>>WITH CREATEOBJECT("age")
>>>
>>>	.CalcAge({^1988/2/29} ,  {^2006/09/21 })
>>>
>>>	CLEAR
>>>	
>>>	? .Years , .Months , .Days
>>>	* CHECK with the correct definition Age = (((Birth+Y)+M)+D)
>>>	?  GOMONTH(GOMONTH({^1988/2/29},.Years*12),.Months)+.Days
>>>	* CHECK with a bad definition
>>>	?  GOMONTH({^1988/2/29},.Years*12+.Months) + .Days
>>>	?  gomonth(GOMONTH({^2006/09/21} - .Days, - .Months), - .Years *12)
>>>ENDWITH
>>
>>18 years, 6 months and 22 days. Correct. I don't understand why you say it's a bad definition. Use pen and pencil.
>>Cetin
>
>Using this method you can not arrive to the same point. None of the dates match.

What point are you talking about? Simple math it is and in code ypu could do:

? GOMONTH(DATE()-22,-6-18*12)

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform