Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Age 70.5
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00461741
Message ID:
00461763
Views:
14
>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?
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform