enter image description hereHow to filter the modified date column, I am creating a view based on I want to show documents which are uploaded by today only but from morning 8 am to 9am .

2 Answers 2


We can't put calculation formulas in filter text so something like Today()+8 etc will not work.

Two work arounds

  1. Use CSR/JSLinks to hide rows which don't fall in that time period.

  2. Use query string filtering. I.e. calculate the date range and sent it via query string ( ex: on link click which open the view page)

  • i can not get your point, i just creating view that shows the documents uploaded today morning from 8 to 10 am. how can i do this?
    – adilahmed
    Apr 26, 2015 at 11:40
  • 1
    You can't create such views using out of the box filtering feature. Apr 26, 2015 at 11:42
  • so how i use ur above said methods , can u give some links , i am not aware that how to create query string filtering and js links
    – adilahmed
    Apr 26, 2015 at 13:34
  • I second the JSLink. It's a very powerful feature of SharePoint that allows you to manipulate the way a webpart/content type looks through HTML/CSS and can traverse through and manipulate each item that the view returns. It allows you to use the fields in that item so you can filter. Very useful in your case.
    – Mike
    Apr 27, 2015 at 4:42
  • 1
    Forget JSlink and whatever solutions programmers tend to provide. The answer by Naveen using an extra Calculated Column, is clean, simple and 100% the SharePoint way of doing things Apr 28, 2015 at 11:02

Another way using only the UI can be this.

First create a calculated column with formula as


This would return 8 if the item is modified between (inclusive of endpoints) 8:00am to 8:59am. You can now use this column to filter.

Create a new view and use the same formula for Modified as you shown in screenshot in your question. Select the And radio button and create a new filter column selecting the calculated column with is equal to set to 8.

Save the view and it should show you all the documents modified today between (inclusive of endpoints) 8:00am to 8:59am. But it will not show you document modified at 9:00am. For that you will have to write a bit more logic. But this should get you started.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.