How to see items added to a SharePoint list/library in the last X days?

  • Article

This post will describe how to create a view of a SharePoint list or library which displays the items/documents that have been added to a list or library in the last X number of days (X is a variable you define).

Scenario

A 'Recent Requests' view is needed on a 'Customer Suggestions' document library to allow the head of the complaints department to see the requests customers have submitted in the last seven days. To do this:

1. Create the library/ list

2. Click Create Column on the Settings menu of the library/list

 

 

 

 

 

 

 

 

3. Enter Date Expire as the Column name

 

 

 

 

4. In the Name and Type section, click the Calculated radio button

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5.

 

 

 

 5. In the Additional Column Settings section, in the Formula box, type [Created] + 7

 

 

 

 

 

 

6. In the Additional Column Settings section, click Date and Time

 

 

 

 

 

 

 

 

 

 

7. Click OK

 

8. Click Create View on the Settings menu of the list/library

 

 

 

 

 

 

 

 

 

9. Under Start from an existing view, click All items or All Documents

 

 

 

 

 

10. Enter Recent Requests as the View name

 

 

 

 

11. Check the Make this the default view checkbox

 

 

 

 

12. In the Columns section, uncheck the Date Expire checkbox

 

 

 

 

 

13. In the Filter section, click the Show items only when the following is true radio button

 

 

 

 

14. In the first drop-down, select Date Expire

 

 

 

 

 

15. In the second drop-down, select is greater than

 

 

 

16. In the text-box, type [Today]

 

 

 

17. Click the And radio button

18. Under When column, in the first drop-down, select Date Expire

 

 

 

 

 

19. Under When column, in the second drop-down, select is less than or equal to

 

 

 

20. In the text-box, type [Today]+7

 

 

 

21. Click OK

 

In my next post, I will explain how to create a View of a SharePoint list or library which displays the items/documents that meet a custom date value.