http://www.endusersharepoint.com/STP/ SharePoint QA en Wed, 20 May 2009 09:09:41 +0000 http://www.endusersharepoint.com/STP/topic/sharepoint-2003-formula#post-6706 Fri, 15 May 2009 09:05:02 +0000 RUANAPE 6706@http://www.endusersharepoint.com/STP/ <p>These are the steps i am following:</p> <p>1. Create new column, calculated type, name it "aweekfromnow" make the formula: = [date submitted] + 7</p> <p>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</p> <p>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: </p> <p>aweekfromnow<br /> Is greater than or equal to<br /> [Today]</p> <p>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].</p> <p>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).</p> <p>This does not work in SP 2003, i get a error because of the use of 'today', can anyone help? </p>