DataFilter and DateTime values

2 posts, 0 answers
  1. Bryan Johnson
    Bryan Johnson avatar
    18 posts
    Member since:
    May 2010

    Posted 02 Sep 2010 Link to this post

    I'm using a datafilter bound to a datagrid which works well, except when trying to filter on a datetime value with the 'equals' operator, which returns zero records even though there are records in the database for the date entered.  The datetime fields in the sql database do not have a time (it is 00:00:00.000), so I'm only dealing with the date.  When I do a sql query directly on the table for the same date, I get the records that match the date queried.  Have you had any issues with datetime values and the datafilter?
  2. Rossen Hristov
    Rossen Hristov avatar
    2478 posts

    Posted 02 Sep 2010 Link to this post

    Hello Bryan Johnson,

    This is a flaw of the RadDateTimePicker control. When it creates a new DateTime and you have not specified the time portion it inserts the current time instead of all zeroes. Please, open a separate support ticket with RadDateTimePicker as its product and ask the team to fix this issue. Opening a separate ticket will raise the priority of this issue and the guys will fix it faster.

    Best wishes,
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top