Help with View Filtering

RS Fuschillo

I need to create a view where the filter actually checks for missing values in a date field.

Field is called Date Completed.

I need a view that displays everything that has not been completed yet

In the List view I can filter by (Empty)... but how does that translate into a View

Thanks

Rick

dlgross


Just create a new View, call it Incompleted then add a filter with Date Completed = Empty, save it

RS Fuschillo

Thanks, but I had already tried that... using the sharepoint interface, there seems to be validation going on and when you type the word Empty, and try to save it creates an error message saying you entered an invalid date.

Brian Seirup

Instead of typing the word Empty, try leaving the field empty, as in blank with nothing in it. It works for me. -Brian