Richard Boarman
Top achievements
Rank 1
Rank 1
Richard Boarman
asked on 22 Mar 2010, 06:19 PM
When I filter on a date, how do include NULL dates in the filter.
Example, I filter for all dates less than or equal to 2/1/2010, but records with a NULL date in that colulmn are also being returned. I want to just return records whose dates are less than or equal to 2/1/2010 and NOT NULL.
Example, I filter for all dates less than or equal to 2/1/2010, but records with a NULL date in that colulmn are also being returned. I want to just return records whose dates are less than or equal to 2/1/2010 and NOT NULL.
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 23 Mar 2010, 07:58 AM
Hello Richard,
Try setting the EnableLinqExpressions proeprty of grid to False and see whether it is working fine.
-Shinu.