Andrew:

This is working nicely – thank you. (I am right-clicking on the calculated column and displaying it using one of the date formats, so that it displays the correct date.)

But I still have a problem (sorry!).

I run the View and then I summarize it. I hide most of the columns (since they are not relevant for the summary). But I would like to display the As-Of Date.

The problem is that the As-Of Date column is out-to-lunch when I use Summarize. What appears to be happening is that the Summarize feature is treating this column as a numeric and therefore is summing all the values in the column.

Edited response – I just discovered if I right-click on the calculated column title and select Display Minimum, my Dates are maintained when I summarize! whistle


Edited by Samuel Kopstick (06/18/12 09:27 AM)
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON