0

I have a SP List with multiple columns, two of them are Start Date and End Date. I added this list view web part to a page and added two date filter columns connected to Start Date and End Date. This filter only works when exact Start Date or End Date is selected.

How can i add Greater than Start Date and Less than End Date functionality to the filter. So that when i select a Start Date and a End Date, all items falling in that range should be visible after filtering.

Thanks

1

In a SharePoint view you can add a filter on any date column but since there is no hint as to the date format, the secret sauce is:

MM/DD/YYYY

You can see how I set up a range below.

enter image description here

If you enter an invalid date, there is a saving grace that SharePoint will save you from yourself.

enter image description here

Don’t forget that you can always use a relative filter as well. An example of this would be to filter on content over the past week, you’d enter a value like this below.

enter image description here

0

Setting up multiple date filters to filter a list by a date range is possible out of the box in SharePoint 2010.

Using date filter web parts to send values to a lists parameters we can get the list to filter by a date range.

But not sure this works for SharePoint Online but it is straight forward using the SPD so it might be possible using below mentioned reference links.

SharePoint: List filtering by date range

Filter List Using Date Range of a Column in SharePoint

Haven't tested it yet for SharePoint Online.

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.