Hello Ben,

From 17.1 when the date is serialized in the Microsoft format, the data source is not able to de-serialize it properly and keeps it as this string. This may give the impression that some operations work (like sorting) because the data source will execute them on the stored strings and under certain conditions the Microsoft-formatted date will have the same sorting result as the one from sorting the actual dates. Other features, like Filtering, try to execute date-specific expressions on these strings and fail.

As for the issue with the hidden column, this has been determined to be a bug and similarly to the previous one I logged it in our internal tracking system with ID: 241197.

Please note that you will be automatically notified in the case I created previously, once the issue is resolved.

If you have any questions, please let me know.

Regards,

Tsanna

I also noticed that when applying an ISO 8601 formatted date, the filter works, but if you add a hidden column to the grid with a date type, the filtering still causes the same error.

attached an example of this.

Hello Tsanna,

I do not believe this is an acceptable solution.

The Microsoft RESTful date format works correctly in the grid as well as with the sorting feature on the grid, which leads me to believe the igDataSource does accept this format.