thinking to find any parameter is available to Filter by empty Field at SharePoint list. But i found one article , is not with Null….is with nothing to compare mean is null!! ha ha..let me share it at below :
I ran into a little quirk this morning that turned out to have an interesting solution. When authors submit articles to the Article Submission Library at EndUserSharePoint.com, there is a date column named “Actual Publication Date” to compare against the “Scheduled Publication Date”.
I want to create a view that shows only the articles that have not been published.
My first pass used the filter section to say “Show items when Actual Publication Date is greater than 1/1/2008″. I figured since it was a date column, any item that had a date in that field would not show up in the view. Nope… didn’t work.
Then I thought “What if you filter for an empty field?” So this time, I set filter to “Show items when Actual Publication date is equal to” and left the value field empty…. Score!!!
Weird one… don’t compare against the date, just leave the filter value empty. You learn something new everyday.