Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Age 70.5
Message
From
10/01/2001 14:31:25
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00461741
Message ID:
00461830
Views:
10
>>>I have two dates: ldBirthdate and ldPlanYear
>>>
>>>ldBithdate = {07/01/1926}
>>>ldPlanYear = {12/31/1997}
>>>
>>>I need to know two things:
>>>
>>>1) Did this person turn 70.5 (70 and 1/2) during ldPlanYear?
>>>2) If not, which year did this person turn 70.5
>>>
>>>For some reason all my calculations are not working. Perhaps I'm overtired? >This should be pretty easy, right? Any help would be greatly appreciated.
>>
>>ldSevPtFive = GOMONTH(ldBirthDate, 70*12 + 6)
>>llTurnedSevPtFive = BETWEEN(ldSevPtFive, ldPlanYear, GOMONTH(ldPlanYear, 12))

>>
>>That work?
>
>I never was any good at date calculations! <g> Thanks, Garret.

James,

Does your plan begin or end on ldPlanYear? See if you don't need
llTurnedSevPtFive = ;
    BETWEEN(GOMONTH(ldBirthDate, 70*12 + 6), ;
    GOMONTH(ldPlanYear, -12) + 1, ;
    ldPlanYear)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform