Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Date(timestamp) filter is not working in adodb recordset RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Friday, April 26, 2019 4:25 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    If the Filter does not accept a function that strips the time part, then maybe build filters like this:

     

       string filter = "[DateTime] >= #1/7/1989 00:00:00#  AND  [DateTime] <= #1/7/1989 23:59:59#";

     

    Friday, April 26, 2019 5:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As user can type the filter string so at one point if user types "1/7/" then i need to show all the entry which has time like 1/7/***

    Nihal.k

    Friday, April 26, 2019 5:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Nihal_dev,

    Since your question is more related to SQL, you could post a new thread in SQL.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    Best Regards,

    Wendy

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, May 2, 2019 6:21 AM