Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A twist on age calculation.
Message
From
31/12/2004 09:30:31
 
 
To
31/12/2004 08:34:36
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00973330
Message ID:
00973529
Views:
24
>>Cetin,
>>
>>Just an update. I've retested with Sergey's and Rick's solution and I am now seeing similar results. Your patch for the random day value cured most of my ills. "Garbage in, garbage out." Thanks again.
>
>Be carefull though. I could reproduce differences up to 28 days. All dates are related with 2/29 and 1/3 (who invented this calendar:)
>Cetin

Agreed. I'm seeing 28-30 in the cases when the DOD falls in the 28-31 day range of the month. I suspect this is the GOMONTH() problem you and Rick referred to. I'm just rescanning the file and tweaking the DOB with the variance. The client is estatic. I'm just happy about it ;-)
Previous
Reply
Map
View

Click here to load this message in the networking platform