Hi Nika, unfortunately the approach you propose still produces multiple row results. If I say everything after 12/1/2015 or MONTHS - 5, the results would be:
Location Status Last Updated Date
Tuscon Active 3/9/2016 <<not needed
Tuscon Closed 4/12/2016 << need only the latest
Tuscon Est 2/20/2016 <<not needed
What is needed is only the results where Last Updated Date is MAX date where Location is the same and Last Update Date is unique. Selecting an arbitrary time period or window will not work as the results go back for several years.
Location Status Last Updated Date
Tuscon Closed 4/12/2016 << latest date of 4 results
Xavier Pend 12/1/2015 << latest date of 2 results
Yellowstone New 2/24/2016 <<latest date of 11 results
Zambie Closed 10/22/2014 <<latest date of 23 results