Unplanned
Last Updated: 15 May 2025 11:57 by Jeroen
Mehdi
Created on: 04 Sep 2024 10:18
Category: Grid
Type: Feature Request
7
The Grid should support built-in option for filtering a column with DateTimeOffset type

I want to filter a Grid by DateTimeOffset? field

 

===ADMIN EDIT===

There are two possible options:

1. Use a DTO in which you have a DateTime field converted as desired by your app from the DateTimeOffset. Filtering, sorting, editing, and grouping on DateTime values are supported out-of-the-box.

REPL example that demonstrates this approach. 

2. Use the Grid Filter Template. As a filter editor, you can use the DateTimePicker component, which supports the DateTimeOffset type. 

REPL example that demonstrates this approach. 

 

 

1 comment
Jeroen
Posted on: 15 May 2025 11:57
option 3, support datetimeoffset with no extra coding. datetimeoffset is a very usefull datetimeformat that was missing in the past. it would be great if the grid would support it out of the box, and even give us a column property or something to show it in original local time zone, utc or currentuserinterface timezone