General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only