You can get the most recent date from a column by asking GridView to display the Maximum Date on a date column and then producing a summary reports.

Attached is a View that lists the items that have been on a PO and shows the date of the most recent PO they have appeared on.

Perhaps this might be useful in getting the information you need.