auto filtering in datetime column

[saravanan k]

Hi,

    i have a datetimecolumn in grid. and my data from the database has values with time also. so when i give the equal to option after selecting a date, it looks for exact match and says no records. is it possible to match only the date string with the input and display all the records for that date. Please help.

Regards,
Saravanan K

[Tsvetoslav]

Hello saravanan,

The best way is to convert the date values coming from the database to a datetime representation which has 12:00:00 AM as the default time. In this way, you will be able to filter correctly on the date-time column in the grid.

Attached is a small sample. Hope it helps.

Regards,
Tsvetoslav
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.

[saravanan k]

Hi Tsvetoslav,

    Thanks for the reply. 

    But this solution doesn't solves my problem exactly. I need to show the date with time as well as such from the db. I just want to modify the checking logic while using the filter. If there is no way to implement the requirement using auto filters, Kindly throw some light on custom filtering for datetimecolumn also. i am new to telerik controls.

Regards,
Saravanan K

[Tsvetoslav]

Hello saravanan,

Attached is a sample that demonstrates how to modify the filtering condition when you have chose the EqualTo function. If you need any of the other filter functions to work in a similar way just following the logic in the attached test project.

Hope it helps.

Greetings,
Tsvetoslav
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.

[saravanan k]

Hi,
       
          That demo was really helpful. I am almost done. Now i have one more problem. The data in the database is stored in UTC time format, butbefore displaying, in the item data bound event handler i am converting the time information to user's time zone (ex) EST.
So before applying the Linq expression i want to convert the it.HireDate dataitem to EST time zone. I tried appending the TimeZoneInfo.ConvertFromUtc() method inside the string. But exception is thrown saying it is not recogonized as a property or method of the entity object in the datasource.

Please help me with the right Linq expression for this case.

Regards,
Saravanan K

[Tsvetoslav]

Hello saravanan,

You can do just the opposite - conver the filter value to UTC format - that way you won't need to apply the conversion to the database values.

All the best,
Tsvetoslav
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.

[Yogesh Vardhmane]

Hello , I am using datetimecolumn in radgrid. I want to fire filter event on dateselect of datepicker. I have set auto post back property for datepicker to true. Still it is not working.

[Tsvetoslav]

Hi Yogesh,

Try upgrading to the latest build of the controls - there was an issue recenlty addressed and you can find the fix in the new dlls.

Hope it helps.

Best wishes,
Tsvetoslav
the Telerik team