Datagrid date field filters

Radzen IDE (Angular)
1

I have a grid which includes a field which is a SQL DateTime data type. The field is populated from Radzen using toISOString(). When the grid is loaded, the data is displayed in UTC timezone which is as per the settings on my computer (i.e. SQL value 2020-04-28 11:51:42.713 is displayed as 28/04/2020 12:51:42 on screen).

I'm seeing oddities when filtering that column on the grid. If I specify "Greater than 28/04/2020 11:00" then the above record is correctly displayed. If I specify "Greater than 28/04/2020 12:00" then the above record is incorrectly not displayed. I seems that the filtering is picking up the ISO datetime value and not the displayed UTC value but, is there an way to alter this?

The column is setup with the FormatString "Medium date with time" and with this Template in the grid:

image

2

The Radzen DataGrid sends dates through the wire via toISOString(). We recommend using UTC dates always as this has proven to work in most scenarios. Browser always treat JavaScript dates as "local". However dates are serialized in JSON as UTC which creates a big discrepancy and problems. Radzen by default uses the utcDate Angular pipe which offsets dates so they are displayed as what their original (database) value was.