I am reading data from DB and dumping it to data Grid in C#. Here whenever I apply filter on recordset for system date type. it is not filtering and returns row count as 0.
In data grid UI, I have text box to type date for filter. The data in grid looks like
1/7/1989 1:45:25 PM
8/7/2000 10:5:20 PM
6/1/1980 5:16:12 AM
and user is typing "1/7/1" to filter all record with matching date. The query to filer is
string filter = "[DateTime] = #1/7/1#";
Recordset.Filter = filter;
int count = Recordset.RecordCount;
Here the count is always 0. But if i do like
string filter = "[DateTime] = #1/7/1989 1:45:25 PM#";
Recordset.Filter = filter;
int count = Recordset.RecordCount;
Then it is able to filter. As user cannot type entire date with time. So want a solution to filter based on partial date input.
Nihal.k