These are the steps i am following:
1. Create new column, calculated type, name it "aweekfromnow" make the formula: = [date submitted] + 7
The reason for this is that if date submitted is 5/1/2009, you will want the request to appear in the view until 5/8/2009, so you need the date submitted plus a week
2. Create a new view, called "Submitted in last week" Add whichever columns you would like, then set the filter to Show only when the following is true:
aweekfromnow
Is greater than or equal to
[Today]
This filter will display the requests from the time they are submitted until 7 days after the "date submitted" value. The caveat with this filter is that if a ticket is 'created' today, but the "date submitted" field is set to 12/31/2008, the request wont be displayed in the view, because the date submitted + 7 is 1/7/2009, which is less than [today].
That should do it. Just ensure that the 'aweekfromnow' field is hidden/not added to views and not necessarily added to the content types (because you want it hidden from the forms...new, edit and view as well).
This does not work in SP 2003, i get a error because of the use of 'today', can anyone help?