Changing the TimeZone of the DateTime fields

[Silviu]

I have a RadGrid displaying data from a SQL DB in which the datetime is UTC.

I would like for the RadGrid to automatically change this datetime so it matches the client's timezone.

How can that be achieved?

[Peter Milchev]

Hello Silviu,

The Grid by design displays the dates as is. Changing the dates on the client would require JavaScript implementation, similar to the one suggested in GridDateTimeColumn to localtime forum thread. 

For an alternative solution, you could consider using, is suggested in the following resources: 

• https://weblog.west-wind.com/posts/2014/mar/27/auto-selecting-cultures-for-localization-in-aspnet;
• https://madskristensen.net/post/get-language-and-country-from-a-browser-in-aspnet;
• https://weblog.west-wind.com/posts/2004/Mar/28/Detecting-and-setting-the-Locale-on-the-Current-ASPNet-Web-Request 

Regards,
Peter Milchev
Progress Telerik