Convert value of a DateTime filter to UTC

[Jason]

Hi,

I have a RadFilter attached to a RadGrid that has DateTime columns.  The DateTime values are stored in UTC format but are displayed to the user in their local timezone. When the user creates a filter on one of the DateTime columns I need a way to convert the value on the filter to the equivalent UTC value and then filter on those results.

Thanks for any help,

jason

[Antonio Stoilkov]

Hi,

Your scenario is not supported and the is no available work around. However, we have planned to implement such functionality in future releases.

Regards,
Antonio Stoilkov
the Telerik team

[Bill]

Was this implemented?  We have the same scenario.

[Antonio Stoilkov]

Hi Bill,

I am happy to say we have implemented a way to achieve this functionality. You could use the new ExpressionItemCreated event described fully in the help article below. The idea is to access the DatePicker control and change the formatting of the control.

• http://www.telerik.com/help/aspnet-ajax/filter-accessing-expression-items.html

Regards,
Antonio Stoilkov
Telerik

 

 

[Holger]

Is there a similar approach for Telerik MVC Grid? I am having exacely the same issue.

I would appriciate if you could post some links.

 

Thanks

Holger