Last Updated: 04 Dec 2019 09:21 by ADMIN
Maria Ilieva
Created on: 12 Dec 2013 13:24
Category: Grid
Type: Feature Request
Add support for DateTimeOffset type of data in GridDateTimeColumn

Posted on: 04 Dec 2019 09:21

Hi Stefan,


Thank you for submitting your feedback. The DateTimeOffset type is a combination of DateTime+TimeSpan. For general visualization you can still use the GridDateTimeColumn and some of the main features like Sorting and DataFormatString will work as expected:

                    <telerik:GridDateTimeColumn DataField="OrderDate" DataType="System.DateTime" HeaderText="OrderDate"
                        SortExpression="OrderDate" UniqueName="OrderDate" DataFormatString="{0:u}">
However, there is also no single control to handle DateTimeOffset values. Therefore, if you are using editing and filtering in your grid, you can try using a GridTemplateColumn instead and its EditItemTemplate you can use a combination of RadDateTimePicker (to handle the Date and Time part) and RadTimePicker (to handle the offset component).


Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Posted on: 27 Nov 2019 11:11

This is very important feature.

The company that I work wit, have clients all around the world and they share the same date information.

Is there any workaround for the problem?

Posted on: 17 Feb 2016 15:44
It's pretty important as a globalized software would need timezone information.
Imported User
Posted on: 13 Dec 2013 11:23

DateTimeoffset is supported for display but not for sorting on a datatimeoffset type

look forward to progress on this

Keep up the good work Telerik Team