I have created a list with:

  • 1 column with a start date
  • 1 column with an end date

I'd like to set up a view where it will check and show only the items where the current date is included between the dates in the above columns.

I can't use a 'greater or equal to' the end date because this shows any items in the future. I'm looking for just the entries valid on the current [Today] date.

Can anyone help at all?

I, sadly, don't have Designer and I'm using SharePoint 2010.

  • Combine the End date greater than or equal to today with Start date less than or equal to today, with AND between the filters Jul 25, 2016 at 11:22

1 Answer 1


Try to build your filter to look like the following

enter image description here

Note : Replace Due date with End date


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.