Method to determine date of latest record per service