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!