Progress® Telerik® UI for ASP.NET AJAX Feedback Portal
Back to Feed
Request a Feature Report a Bug
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
13
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


				

			

		





    



        

            

                    Create an account
                    Log In

                
View

                
            

            
Type

            
            
Status

            
                
Category