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

				
		
4 comments
ADMIN
Eyup
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}">
                    </telerik:GridDateTimeColumn>
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).

 

Regards,
Eyup
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.
Stefan
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?

Mark
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
Excellent... 

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