Hi, I have few columns with date and date time values and the REST JSON returns correct values but on grid widget either null or empty string is displayed. If I change to text column - correct value is displayed. Is there any setting that can cause this behavior?
I experienced the same issue. I was able to resolve it by using ISO 8601 format for the dates and datetimes in the JSON.
can you please elaborate?
We were retrieving the data from an MS SQL table. In the JSON data sent to the DataGrid we made sure the data was formatted like this 2021-12-24T20:23:31+00:00 instead of the format returned by default by the query.