Hi, I have a report which reports on all the date's that a patient has had office visit. The data is limited using a parameter for a start and end date for the contact date. I need to display the most recent contact date (as defined in the parameter) and the previous date.
I am using the MAX function for the Recent Contact Date and that is working,
I really need help displaying the Prior Contact Date field.
Below is an example of the data. Parameter contact date from 3/1/14 to 4/1/2014
I would like to display a single line for each id:
PATIENT_ID Recent Contact Date Prior Contact Date
1234 4/01/2014 3/15/2014
4567 4/01/2014 3/12/2014
Any ideas how I can accomplish this?