Need to track medical claims of people who are 65+ Time period of measurement is two years, from Mar2007 to Mar2009.... what if during this time someone turns 65 (example in 2008)... using the code that has '01APR2007'd wouldn't be accurate b/c the person would turn 65 in 2008 and should be captured after he turns 65... so 1) pull all members who are 65 as of today and then when I compare that table to get the actualy members who had medical claims during the last 2 years and then only choose those ones apply... here is an example

NAME DOB CLAIMS Date of Fill PersonA 3/5/1944 1 2/5/2009 (this claim would be excluded) PersonA 3/5/1944 5 3/8/2009 (this on is included b/c at the time of fill the person was alrady 65) How do I put this in a code?