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.
Create a calculated column and use the
You should create a new calculated column with
NOW() function, as I show you in the following screenshot
Make sure you select "date and time" under "Data type returned"
This will return the current time, acording the regional settings of the server.