Forum Discussion
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 last 6 months list items.
Thanks for your answers/support in advanced.
I tried in this way and it works.
4 Replies
- Ahmed_Masoud97Steel Contributor
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
- NaligurtanBrass Contributor
I tried in this way and it works.
- GullettBrianIron Contributor
Have you tried a filter like this in your list view settings using "Created" or whatever date column and the dynamic [Today] option?
That might be easier to do through gear > List settings > Create view, instead of from the "Add view" option in your list.
- NaligurtanBrass Contributor
Thanks. I already tried [Today]-183 and it does not display correctly for some reason.