Date field in view Filter Criteria, where date may be blank I have a date field attached to a content type and it's not a required field. I want to use this date to control the display of the content using a view and it's filter criteria.

Some content may have blank dates and some may have a start and end date.

Is there a way I can set up the view to check for all of these conditions?


content is published
AND content type is TYPE
AND Start date is blank OR Start date is not blank AND start date is &lt;= NOW
AND End date is blank OR End date is not blank AND end date >= NOW
The conditions I had set above were too many


content is published
AND content type is TYPE
AND Start date is blank OR Start date is not blank AND start date is &lt;= NOW
AND End date is blank OR End date is not blank AND end date >= NOW


and should have been:


content is published
AND content type is TYPE
AND Start date is blank OR start date is &lt;= NOW
AND End date is blank OR end date >= NOW


because the NOT blank is implied.

Using the 'And/Or, Rearrange' feature of the Filter Criteria, I was able to create 3 groups joined by AND's with Group 2 and 3 joined by OR's. Like so: