I have a dataset with all the events which have occurred under their unique ID.
I have already retrieved data to confirm that an event occurs in 1/1/2011-06/30/2011 and another event occurs between 1/1/2012-6/30/2012. Sometimes multiple events occurred in each date range.
I need to combine data for the two date ranges into one row on their unique ID. I also need to pull only the max date (most recent date) in each date range if multiple events occurred.
How do I do that?
I have already retrieved data to confirm that an event occurs in 1/1/2011-06/30/2011 and another event occurs between 1/1/2012-6/30/2012. Sometimes multiple events occurred in each date range.
I need to combine data for the two date ranges into one row on their unique ID. I also need to pull only the max date (most recent date) in each date range if multiple events occurred.
How do I do that?