We help IT Professionals succeed at work.
Get Started

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?

Last Modified: 2012-08-13

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"?

Watch Question
Most Valuable Expert 2013
Awarded 2012
This problem has been solved!
Unlock 2 Answers and 4 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE