Date Time Col Doesnt Find Date in Timestamp

[bradley baker]

Using a GridDateTimeColumn for a timestamp field and I want the users to be able to search the dates IE "10-25-2009" but because its a timestamp field "2009-10-25 12:12:01"  it never seems to find any results even though there are records for the dates.  How do I resolve this?

[Yavor]

Hi bradley,

In order to make this work, there are two options. You can either enter the whole value (like 2009-10-25 12:12:01), or you need to have a separate field, containing only the date, in the underlying datasource, which would allow you to subsequently only enter the date. Other than this, there is no other option to handle this automatically.
Yet another alternative would be to intercept the filter command, and alter the user input, for example by adding the hour part, to get a full timestamp value.
I hope this information helps.

Greetings,
Yavor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[VIRUX]

Hello Telerik,

Can I get demo application , an easier way pls...
Even "Contain" filter on datetime bound column is not working ...
Now what I do is just bind to string bound column and filter with "contain"
Intercepting the filter command needs much effort and it should not be that difficult :(
Thanks

[Martin]

Hello VIRUX,

I am afraid that the options described by my colleague Yavor are the only ones that are currently available. If you face any problems implementing any of the approaches above, you can open a formal support ticket and send us a small sample demonstrating your scenario. This way we will be able to debug it locally and provide you with more to the point resolution.

I hope this helps.
Martin
the Telerik team

[Mihai Dinculescu]

I apologize for resurrecting this thread but because the problem still exists I'd like to post the following solution which I found to be easiest. Yavor hinted it too but not in a very explicit manner.

The solution is to strip down the hour, minutes, seconds from the Date field used to populate the data.

For example if you bind from a LINQ datasource you can do the following:

from _r in dc.Orders
select new
{
_r.OrderDate.Value.Date,
}