Please email me code at [email protected]
Also send database sql dump.

Hi Abu

I think I found the problem, when ever I update a row with January, April, August or December it changes the date to blank.
I already checked in the other grid and it happens the exact same issue.

January – Enero
April – Abril
August – Agosto
December – Diciembre

As you can see, these 4 months are different and that may cause the problem.
If you watched the video, you can see that the grid update the 3 letters of the month name, from Dec to Dic becasue I use the Spanish localization.

I hope it helps.

setlocale(LC_TIME, 'spanish');
date_default_timezone_set("America/Mexico_City");

This could affect the update query when the grid send the data to the database?

This could be a solution, but we are not using strftime() inside lib. We are using strtotime that does not support setlocale() function.

2 solutions:

1. rename the shortnames to english in spanish localization file of grid.
2. using custom on_update handler, search and replace 'Dic' to 'Dec' before it goes to database.

Emailed you sample for #2.