>>>>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)

It always ends on 12/31