SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create a view whereby it does not include any items which does not have the 'next review date' as blank, i.e. only includes items which have this field populated. How do I say blank to a SharePoint? It does not recognize [] or [blank] or "".

share|improve this question
Thank you .. this solution work great!! Thank you form the bottom of my heart! – user21753 Jan 6 '14 at 14:30
Did you get a resolution to this in the end? I have tried the answers supplied already with no joy. – Jonny Wright Jul 31 '15 at 11:26
@JonnyWright The top-voted answer worked perfectly for me. Do you still need help with it? – thanby Feb 16 at 16:16

Create a list view and set the filter; where date time column is not empty (see below)

enter image description here

share|improve this answer
does this work for lookup columns? – egidiocs Apr 3 at 6:34

the view's filter will be: 'next review date' in not equal to [leave it blank - don't write anything]

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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