I have a column with "start date". I also have a column called "expire date".

How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or greater than "expire date"?

I have tried to use "start date" == [Today] OR "expira date" == [Today]

Doesnt work in SharePoint 2007. Any help would be apreciated.

2 Answers 2


You can create/modify a view and apply the filter on the start date. To create/modify a view, go to list settings-> Scroll down to bottom and you will see a section named Views. Here you can click on exiting view or create a new view. In the view you can filter based on the start date in the Filter Section.


Based on your update in the question. This is how you can approach it. Create a Calculated column "DateDifference" and use the follwing formula [StartDate]-[ExpireDate] and have it return a number. Now the number can be either negative, zero or positive. Then put a filter based on this new column which will be like "DateDifference" is greater than or equal to 0

  • The filter command [Today] works with this but I want the list to be seen for a bit longer period.
    – Cherubel
    Commented Dec 11, 2013 at 11:24
  • 1
    You can add or subtract days from [Today] something like [Today]+3 or [Today]-3 Commented Dec 11, 2013 at 11:34
  • 1
    Damn... Was kind of hoping that in stead of [Today] I could use [start date] or [expire date]. Values from those fields are what I need...
    – Cherubel
    Commented Dec 11, 2013 at 11:36
  • 1
    See my update. Hope that helps. Commented Dec 11, 2013 at 11:55

its long winded but,, you need to add a filterd webpart to the list page:

this is a step by step guide with images!


enter image description here

  • 2
    This post has almost no information in it. The link does not seem to work today.
    – jpaugh
    Commented Jan 9, 2018 at 19:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.