Creating Sharepoint 2013 views based on date filters

Copper Contributor

Thanks in advance and this may be very basic.

 

I'm trying to create 3 different views in sharepoint 2013 document library based on a date column (which are review dates of some plans basically)

  1. Plans reviewed in the last 6 months
  2. Plans reviewed between 6 months and 10 months
  3. Plans that are more than 10 months old

I have used filters, review date is less than [Today]-180 for 6 months

greater than [Today]-180 and less than [Today]-304 for dates between 6th and 10th month

Greater than [Today]-304 for 10 months and more

 

But the filter doesn't seem to be working. Even thought the dates are shown it is not being picked up in the views. I don't have SP designer.

Please any help would be greatly appreciated.

 

3 Replies

If you create a view using the Created or Modified date in the view filter instead of the user created date column in the same list, does it work?

 

 

No that doesn't work either, I tried to put modified less than [Today]-1 just to see if it can show only the document modified from yesterday. But it still shows different list!

Can you check the build number of your SharePoint farm? I'm wondering if an update is needed

 

This blog tells you how to get the build number

http://itgroove.net/mmman/2015/05/01/how-to-get-the-sharepoint-farm-build-version-using-powershell/