I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this earlier, only with items that were added in the current week, by creating two columns, 'Week Start' and 'Week End', and filtering by Created falling between those two. Simple enough. However, filtering list views does not allow for complex functions, nor does the [Today] function recognize time, causing an issue. Is there any workaround for this? Thanks.

2 Answers 2


Create a calculated column and use the HOUR function, =HOUR(Created)

  • Thanks so much, I had been trying to use a Date/Time column and couldn't get some of my more complex functions to work. Jun 24, 2015 at 12:46
  • 1
    ViewMaster365.com/functions is an up to date list of Functions & Syntax I compiled recently out of the (sometimes incorrect) resources on the Web. Jun 25, 2015 at 8:54

You should create a new calculated column with NOW() function, as I show you in the following screenshot

screenshot of new column

Make sure you select "date and time" under "Data type returned"

This will return the current time, acording the regional settings of the server.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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