Forum Discussion

EthanHAu's avatar
EthanHAu
Copper Contributor
Nov 02, 2023

Sharepoint List View - Showing items from the past 12 hours.

Hi there, 

 

I need to create a list view that shows items modified within the last 12 hours. This produces a report that displays over midnight (1800-0600) that is then captured by my team. I have been struggling to create a view that excludes the items created from the morning of the same day. 

 

I have attempted to create a calculated column that calculates the time from NOW (time view is opened) against the time of last modified but this seems to error often. 

 

Any help would be appreciated. 

developer
Lists
SharePoint Online
  • luis-ribeiro's avatar
    luis-ribeiro
    Brass Contributor
    Nov 03, 2023

    Hi EthanHAu 

     

    I believe you will not be able to create a filter in the modified field to match those rules.
    I don't have the full solution, but maybe you can create a calculated column to have the hour value of the modified date (0,1,2...) and then it may help to to create a view.


     Regards,

Resources