I have a list with information regarding when we last visited our clients, two of the columns are:

Last - This is a date picker which tells us the last time we visited the client

Next - This is also a date picker which tells us when we will be visiting the client next


I want to create a view called 'Flagged' with a filter that shows us which client visits we missed based on the next column

So for example if we have to visit a client called 'CompanyA' on the 20th of October and we miss that date, 'CompanyA' will show in the flagged view.

I'm just not sure how to build the filter

Filter Image


  • how you tell/enter the value in sharepoint, i mean if you miss a date then how sharepoint know about it?
    – Waqas Sarwar MVP
    Commented Oct 18, 2014 at 4:16
  • If we have to visit the client on the 20th of October and then on the 21st Of October we have not changed the next column date the item is shown in the view Commented Oct 18, 2014 at 4:28

1 Answer 1


What i Understand is that if you set the Next date to Oct 20th and you miss it then you will not change it. Now you want to create a view which will show you if you miss a date.

I think you filter is simple, if Next is less then Today. like this.

enter image description here

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.