Forum Discussion
Solved
How to create a view to display the last 6 month items in SharePoint list
Hello All, I have a SharePoint list and there are many items. I can filter items for the last 6 months. However, I want to have a view when someone selects that view, the view always shows the la...
I tried in this way and it works.
Create or edit the view, then set the date column to “is greater than or equal to” [Today]-183 and, if future dates must be excluded, add an AND condition of “is less than or equal to” [Today]. This creates a rolling 183 day view that updates whenever the view is opened. SharePoint view filters support [Today] with day offsets, but not an exact calendar month calculation, so [Today]-183 is an approximation of six months. For large lists, index the date column and place that condition first to avoid List View Threshold issues. Use filtering to modify a SharePoint view | Microsoft Support