|
dbWeb > Blogs > Leslie Price > Posts > Create a filtered view for a list to show the last 30 days
|
3/27/2009
In this example, I have a list of product update documents with a date column titled Update. When I view this list, I only want to see updates for the last 30 days. I will accomplish this by creating a view that uses the date field titled Update as a filter to only show the most recent 30 days of activity.
Here is what the list looks like before creating this filtered view.
Creating the View
- From the list screen, choose Settings, Create View.
- Choose the view format, for this example I have selected Standard View.
- Enter a name, check the box to make this the default view if desired, select the columns to display and sort order.
- In the Filter section, for "Show the items when column" choose the column containing the dates.
- From the operator list, select "Is less than or equal to"
- In the value box type [today]
- Select "And"
- For "When column" again select the column containing the dates.
- From the operator list, select "Is greater than or equal to"
- In the value box type [today]-30. The filter section should look like the example pictured:
11. Select any other options for the view, and then choose OK.
This is how the list looks with the new view applied:
|
|
|
|
|
|
|