Forum Discussion
SharePoint Date/Time Filter
I have a SharePoint list with a large number of entries. There is a Date/Time column in the following format: mm/dd/yyyy hh:mm. I have need to filter the data between yesterday at 14:00 and today a...
Rob Nunley I know this is an old post, so this may not be needed by you any longer but could still help someone in the future who stumbles on this.....
A simple solution: I like to use a filtered view for each year for any lists that have significant entries in them. I do this in a new view and then call the view whatever year I am using. I have an example here where I have done this using the Created column:
Created
is greater than or equal to
1/1/2023
AND
Created
is less than or equal to
12/31/2023
Gets me all of 2023.
Looks like this in SharePoint:
I do similar for 2022, 2021, etc to get the yearly views as needed and have the list not show the 14,000 items (which breaks now that we are online instead of on-prem 😉 ...).
- thank you!!! still relevant and needed
