The [Today] parameter is a dynamic parameter that can be add some enormous benefit in creating a custom view. Using {Today] is powerful because it can filter a column based on the current date.
Some examples of ways to use the [Today] parameter are:
- Displaying items created over the past week
- with a filter for showing “Created is greater than or equal to [Today]-7”
- This view could be called “Recent Stuff”
- Displaying items or documents that have expired:
- with a filter for showing “Expiration Date is less than [Today]”
- Displaying deadlines values that are less than 7 days from now:
- with a filter for showing “Deadline is greater than [Today]+7”
- Showing all tasks that are due in the next 7 days or overdue:
- with a filter for showing “Due Date is less than [Today]+7 OR Status is not equal to Completed”
Steps to Create a [Today] filtered view:
- Go to your Library or List Settings.
- Click on Create a View.
- In the view creation screen, scroll down to the Filter section.
- Filter for the desired situation. Use the examples above as a guide to set the parameters as needed.
- In this screenshot, I am filtering for all documents that have been created OR modified in the last 3 days. These settings result in creating a “Recent Stuff” view.
- When typing the expression using the [Today] parameter, make sure to type the entire expression without any spaces.
One limitation of the [Today] field is that it cannot be used for formulas in Calculated Columns.
Related Posts:
How to Create a Dynamic [Me] Filtered View in SharePoint
Please leave a comment if you found this post useful.