find two consecutive dates
I have a data set of patients with their lab test results (+ the date of test).
Each patient may have several lab tests. I want to find the latest date of lab test (abnormal one) and the exact previous one (based on the date) for each patient.
Any recommendation on how I can get the latest date and the previous one (two consecutive dates)