DataFilter and DateTime values

[Bryan Johnson]

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?

[Rossen Hristov]

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,
Ross
the Telerik team