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

Question

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 1

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.

[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.