This seems like something that would be commonly asked, but I can't seem to find my own answer, so sorry if it's a FAQ.

We have a new asset management system that automatically collects information about computers on our network. We have to build a view that is used by our help desk system to import asset information. One of the nice features is that the asset management system goes out and retrieves warranty information from the manufacturer. The bad news is that it doesn't distinguish between types of warranties if there are multiple types (such as full warranty, parts only, etc.). For our view, we'd like to retrieve just the date that is furthest out.