Here is a solution I use to grab the latest date:
Select (fields) from (table) group by (patient id) having patient date = max(patient date) . This will give you only the latest date for each patient id.