Hi,
I am using jQxGrid of version 3.3. I have a grid in which a column is of type ‘date’
datafields : [ {
name : ‘startDate’,
type : ‘date’} ],
text : ‘Editable Phase Start Date’,datafield : ‘editDate’,width : 150,columntype : ‘datetimeinput’,cellsformat : ‘MMM yyyy’
The issue I am facing is, the dates I enter in the grid is getting saved wrongly. I have tested in different versions of IE (IE9, IE10, IE11).
It works fine in some versions of IE and does not work in few versions of IE.
For instance if I enter dates in the grid as below
Start Date End Date
01-AUG-14 31-AUG-14
01-AUG-14 31-AUG-14
01-SEP-14 31-SEP-14
01-OCT-14 28-OCT-14
01-NOV-14 28-NOV-14
28-DEC-14 28-DEC-14
But data saved in the database will be
Start Date End Date
01-AUG-14 31-AUG-14
01-AUG-14 31-AUG-14
01-SEP-14 31-OCT-14
01-NOV-14 28-DEC-14
28-DEC-14 28-DEC-14
The data passed from the grid in the form of JSON is going wrong
Please help!