Filtering Sharepoint Lists on a "Now" or "Today"

sharepoint
Nick Ryberg picture Nick Ryberg · Apr 13, 2009 · Viewed 182k times · Source

I'm trying to find an effective method of filtering Sharepoint lists based on the age of an item. In other words, if I want to find list items that are 7 days old, I should be able to build a filtered view on the data.

There is a hack to build a "Today" field that works, but doesn't filter properly.

Does anyone have any good ideas?

Answer

Ryan picture Ryan · Sep 11, 2010

If you want to filter only items that are less than 7 days old then you just use

Filter

  • Created

  • is greater than or equal to

  • [Today]-7

Note - the screenshot is incorrect.

New items - created in last 7 days

[Today] is fully supported in view filters in 2007 and onwards (just keep the spaces out!) and you only need to muck around with calculated columns in 2003.

Related questions

Best way to resolve file path too long exception

I created a app that downloads all document libraries in a SP Site , but at one point it giving me this error (I tried looking at google but couldn;t find anything, now if anyone knows any trick to solve …

Read More
Auto number column in SharePoint list

In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?

Read More
How do you upload a file to a document library in sharepoint?

How do you programmatically upload a file to a document library in sharepoint? I am currently making a Windows application using C# that will add documents to a document library list.

Read More