We are currently facing an issue when updating a row that contains a date column, the value is not serialized with the right regional format :
In the datasource, we have the value like this (which match our value in database) :
DATE : Thu Jan 26 2023 11:58:08 GMT+0100 (heure normale d’Europe centrale)
It also displays well on the grid with the right regional format, but when we update a cell (not the date column) on this row and using the saveChanges updating grid method, the serialize date looks like this :
DATE : "2023-01-26T10:58:08.000Z"
It doesn't match our database value anymore, it has 1 hour less.
We tried to set enableUTCDates: false, because as it is indicated in the documentation : "It serves the purpose to specify dates serialization." but it doesn't solve the problem, so maybe it doesn't affect the serialized values for updating.
Is there another option to keep the right regional format when serializing updating row values ?
Thank you for the answer.
I tried your solution and it worked well, however we decided to manage the date format on server side.
The question was more to know if it was normal, a bug, or if an option existed to send dates in other format than UTC. So it is not the case but that's alright we found a solution to this issue.
Thank you for your explainations.
I am glad that you found a solution and managed to achieve your requirement.
Thank you for using Infragistics components.
Regards,Riva IvanovaAssociate Software Developer