How can I create a list view with a filter on a date column so that only items for the most recent date are displayed?
Posted on 2012-08-10
I have created a custom list in SharePoint 2007 (MOSS 2007). There is a date column called week ending. I would like to be able to create a new view on the list that shows only items that match the maximum value within the "Week Ending" column. For instance, if I have 4 items with a "Week Ending" value of 7/20/2012 and 3 items with a "Week Ending" value of 8/3/2012, I would like for the view to display only the items with a "Week Ending" value that matches 8/3/2012. I created a Calculated Column set to =Max([Week Ending]) but it returns the Week Ending value of the current row.....not the maximum Week Ending in the list. I also tried to set the filter to (Where [Week Ending] is equal to [Max Week Ending]) and it gives me a "Filter value not is a supported date format" error. The [Week Ending] column is a date only type and the [Max Week Ending] column is set to return a date only type. Any ideas on how to achieve this using only "out-of-the-box techniques"?