Filter and and edit datetimeoffset grid columns

Hi Henrik,

The DateTimeOffset is a bit specific structure. It represents a date-time data structure that defines a point relative to the UTC time zone - it is a value that is not fixed.

Let me share a couple of problems with a built-in support of DateTimeOffset in the Grid:

• Such functionality would require the Grid to automatically convert the DateTimeOffset to a specific time (like browser time). However, it may not always have to be browser time since the app may need time zones or the user might be traveling.
  
  
• Another problem is that the DateTimeOffset is actually serialized as an object - it cannot be easily stored so the application will also have to convert it anyway.

That being said, you may post a request for such a feature in our Feedback Portal. This will let you explain your goals and requirements, even perhaps add a sample of what API and functionality you would expect it exposes. Also, you can elaborate on what is your envision on this matter and how the Grid should behave in such scenarios. If it gets good traction with the community, we will consider its implementation.

For the time being, you can use a DTO in which you can have a DateTime field converted as desired by your app from the DateTimeOffset. Filtering, sorting, editing, and grouping of DateTime values are supported out-of-the-box already.

Here is a REPL example that demonstrates this approach.

Regards,
Nadezhda Tacheva
Progress Telerik