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? – Rune Sperre Apr 9 '20 at 12:46
  • sharepoint 2016, onpremise , classic view.. date should be on the basis of current date – Muskan Apr 9 '20 at 12:50
  • Are you planning to apply the filter on the same list which has two dates columns? – GSD - SharePoint Apr 9 '20 at 12:52
  • @HabiburRahaman : Yes – Muskan Apr 9 '20 at 13:01

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). – Ganesh Sanap Apr 9 '20 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 '20 at 13:12
  • 2
    Use AND operator instead of OR. Check updated screenshot. – Ganesh Sanap Apr 9 '20 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 '20 at 13:22

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.