Page 1 - has ADF button which on click must select the row from the ViewObject that has MAX(date_column). The customer shouldn't need to click on any row. This intelligence must be contained inside the action.
Navigate to Page 2 presenting that single row as an ADF form.
My problem is that I don't see where or how to stick this MAX(..) function in the view object.
How about implementing this in an other vo which gives you the key of the row with the max value. This key you peas to the form. A similar use case you can find here http://wp.me/pcBZk-4M . The new vo you Max() function into the select statement: select * from yourtable where attribute=Max( attribute).