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

Have you tried this: create a Computed column, called 'Expiry', with a formula that amounts to '[Created] + 7 days'. Then use the computed column in your View's filter. Let us know whether this worked or what problems this poses!

Answer 2

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

Filter

• Created

• is less than

• [Today]-7

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