How 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 .
We can't put calculation formulas in filter text so something like
Today()+8 etc will not work.
Two work arounds
Use CSR/JSLinks to hide rows which don't fall in that time period.
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)
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
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.