I have a list where I have 2 date time columns names as start and End date. I'm looking to create a list where items can be filtered if they lies within these date ranges of start and end date.

Can someone please help me with the list view filter that we have in Views through which we can achieve the above output.

I'm using SharePoint 2016 , classic list view for this.

Thanks in advance.

  • What SharePoint version? Classic or modern view? Should the date you filter on be a static date or the current date? Apr 9, 2020 at 12:46
  • sharepoint 2016, onpremise , classic view.. date should be on the basis of current date
    – Muskan
    Apr 9, 2020 at 12:50
  • Are you planning to apply the filter on the same list which has two dates columns?
    – SP 2022
    Apr 9, 2020 at 12:52
  • @HabiburRahaman : Yes
    – Muskan
    Apr 9, 2020 at 13:01

1 Answer 1


Try your list view filter something like below:

enter image description here

  • You can change the field names according to your list structure (Use End Date instead of Due Date in example). Apr 9, 2020 at 13:04
  • this will not suffice the requirement as if the start date is anything less the value of a, it will show the items . What I;m looking for is to filter items between the start date and end date . I did tried the above scenario though, but it didn't worked
    – Muskan
    Apr 9, 2020 at 13:12
  • 2
    Use AND operator instead of OR. Check updated screenshot. Apr 9, 2020 at 13:13
  • 1
    Thank you soo much, Much appreciated. I was confused with the logic a bit...My bad! Thank you for the help one again :)
    – Muskan
    Apr 9, 2020 at 13:22

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.