I want to implement a date range filter on my sp2016 list, having two date fields (To and From date) and where a person can select the date range and filter the list data. I tried with the out of box date filter web part but it is causing some issue. Can anyone suggest some other way to implement a date range filter on a list. Thanks.

  • Write more you question, fiter date column, need change color items or group items? Dec 14, 2018 at 8:29
  • @Fox I want to filter the list data on the basis of from and to date.
    – notorious
    Dec 14, 2018 at 9:12

1 Answer 1


You can do this in two ways:

  1. By Creating View:


    1. How to Filter a SharePoint Date Column by Range
    2. See "Filter on dynamic dates or current user" section in Use filtering to modify a SharePoint view.
  2. By Using SharePoint Designer

    Source: Filter List Using Date Range of a Column

  • Thanks for the response. First approach is not what I want to implement. I want to have a date range filter on my list with two fields TO and FROM date and on the basis of dates selected on the date field users can filter the list data. About the second approach I have tried the same thing but it is causing some issues on my list. I am not able to modify the list view, it gives the error that invalid date fields. And the search box also gets invisible form the list. As mentioned [here]( sharepoint.stackexchange.com/questions/254100/…)
    – notorious
    Dec 14, 2018 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.