[OutSystems Data Grid Web] Date and DateTime column is not working 
Web icon
Forge component by Platform Maintenance

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.