Checking for empty or null dates in SharePoint
A client asked me today how to create a view filtered so that only items that where missing their Start Date, Due Date, or both.
First, create a calculated column DatesMissing with the following formula:
=NOT(AND(ISNUMBER([Start Date]),ISNUMBER([Due Date])))
Don't forget to set the type to Date!
Create a new view, and set the Filter to DatesMissing 'Is Equal To' 'Yes'
The view will only show you the items missing either one of those dates.