Forum Discussion
Rob Nunley
Mar 27, 2020Brass Contributor
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...
Sudharsan K
Mar 28, 2020Steel Contributor
Hi,
If you want to do it within the list, then try creating a computed column and make sure your condition of datetime is applied which will be true or false. Then you can try filtering the computed columns for values with true. Try using column formatting and apply the condition in the new column using column formatting. Please refer the below link for some samples using column formatting.
https://github.com/SharePoint/sp-dev-list-formatting
If you want to do it within the list, then try creating a computed column and make sure your condition of datetime is applied which will be true or false. Then you can try filtering the computed columns for values with true. Try using column formatting and apply the condition in the new column using column formatting. Please refer the below link for some samples using column formatting.
https://github.com/SharePoint/sp-dev-list-formatting