How to show only last date value in Views on multiple value datetime cck field?

I have a site with a required datetime CCK field with unlimited values. In views, I want to be able to show (and possibly sort) on only the last date value. I know there's "group multiple values" with show X values, starting from and ending fields, but I can't seem to find anywhere how to make it show only the last date value in a node.

Thanks for the help and sorry if I'm missing something obvious.