<< I use a listview which has selections where listeddate < .#DATE + 30. What I am finding is that if the date is null it does not display so it looks like null dates are > .#DATE. I kind of thought it would be the other way around. >> It's both ways round, or neither way round.
Since NULL is unknown, those records will not show up with LISTEDATE < (.#DATE + 30) or with LISTEDATE > (.#DATE + 30). You need to do something like: (ListEDate < (.#DATE + 30) OR ListEDate IS NULL) -- Larry
