Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is best way to calculate age
Message
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:
01155681
Views:
27
>>>>>See Re: What is best way to calculate age Thread #1155605 Message #1155645
>>>>>
>>>>>What should this class return for today and 02/29/1988?
>>>>
>>>>18 years, 6 months, and 22 days.
>>>
>>>How did you calculate that? BTW, it returns 16 days.
>>
>>It returns 18,6,22 as I stated. Are you using the latest version? This class was updated Jan. 2005. The old one may have produced a different result. See the documentation for explanation of how this class does its calculations.
>
>Am I right to go back to the person's birthday knowing his age today?
>=MESSAGEBOX(GOMONTH(GOMONTH(DATE(),-18*12),-6)- 22)
If today he/she is 18 years 6 Months and 22 days, yes, but you could use:
=MESSAGEBOX(GOMONTH(DATE(),(-18*12)-6) - 22)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform