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: