How do I get the record with the most current date for each person's ID?
I am doing this in sql.
right now I have
Select ID, testDate, Status1
from myTable a
where testDate = (select max(testDate) from myTable b
where a.ID = b.ID)

but this gives me the previous day date(when i ran today, it gave me yesterday's date)but in the databse the latest date is 11/1/2012
what am I missing?
TIA