jQGrid datetime server side filter not working with specific date format
We have used Trirand.Web.UI.WebControls.JQGrid in our Asp.Net application, We have also enabled server side filtering setting LoadOnce = false. We have also implemented localization for Date format for that we are using below code
JQGridColumn jc = new JQGridColumn();
jc.DataFormatString = "{0:" + UserDateDisplayFormat + "}";
CustomFormatter jcformatter = new CustomFormatter();
jcformatter.FormatFunction = "FormatNullDateCellValue";
jc.Formatter.Add(jcformatter);
Where "FormatNullDateCellValue" JavaScript function is converting datetime format for display in grid.
Now we are facing issue with specific date format "dd-MM-yyyy" when date is lower then 12 (e.g. 10-02-2018).
For server side in Asp.Net we have jqGrid_DataRequesting method where we got filtered result with 1 record count.
But from there when code reaches to loadComplete(data) JavaScript method we found record count 1 but not row data.
This is strange from we have got so far http://www.trirand.net/forum/default.aspx?g=posts&t=3964 but this is not helping us.
Thanks in Advance.