Incorrect Date Sorting in Grid (Ascending order only)

[Jason]

I am using Kendo UI Web v2012.3.1315.

On my grid there is a DOB field for Date of Birth.  I have attached the DOB values that show in the grid.

I build my data as a string in JSON format here is an example:

{ "intReportID" : "1245", "sysReportNum" : "12-336", "sysAddress" : "9TH Ave SE & Hill St SE", "sysReportDate" : "1/5/2012 8:57:00 PM", "intUnitType" : "1", "vchLastName" : "PROUSE", "vchFirstName" : "CRYSTAL", "chrGender" : "F", "datDOB" : "3/3/1979 12:00:00 AM", "bolVehOwnerSame" : "False", "Gender" : "Female" }

The columns are also defined in JSON:

{ field: "datDOB", title: "DOB", format: "{0:M/d/yyyy}" }

Same with the Schema Model:

{fields: { "datDOB" : { type: "date"}}}

The DOB column sorts mostly fine.  In decending order the blanks are all at the end of the grid which is okay.  But in Ascending order the blanks start at position 49 and position 48 is incorrect:

47: 11/11/1958
48: 1/11/1969
49-62: blank
63: 3/25/1959

You would think Ascending would put the blanks at the start and not mess up the sort order of one item.

Any ideas?

[Jayesh Goyani]

Hello,

Please update your js file, now this issue is resolved.

http://jsfiddle.net/jayeshgoyani/pke9q/2/

Note : In Previous version it applied sorting only on data (means it ignores the null value).

Thanks.
Jayesh Goyani

[Jason]

Which file(s) should I update?  I am using the latest version do you want me to use the beta one?

[Jayesh Goyani]

Hello,

Sorry, its my mistake.

I also used same version.

http://cdn.kendostatic.com/2012.3.1315/js/kendo.all.min.js

I am not able to reproduce this issue.

Thanks,
Jayesh Goyani

[Jason]

The js files I am using are:

jquery.min.js (jQuery v1.8.2 jquery.com)
kendo.web.min.js (v2012.3.1315)

They were in the Kendo UI Web Q3 2012/js folder.  I don't see the 'all' file.

[Jayesh Goyani]

Hello,

Please check my attached files for reference.

Thanks,
Jayesh Goyani

[Jayesh Goyani]

Hello,

if possible then please create separate test page/project to test this functionality.

Thanks,
Jayesh Goyani

[Jason]

Here is my Fiddle page.

http://jsfiddle.net/NqrDS/

Set the page size to 50 and page 1 and 2 will have the block of blanks in Chrome.  In IE the blanks are not sorted at all they are distributed throughout.

[Hamlet]

After 2 years from this question, I have the same issue now. Any ideas ?

[Jason]

I took a look at our website and the issue is still present.  I have not updated the Kendo controls though so I am probably way out of date with the code.  When sorting descending the nulls/blanks are at the end, but the ascending sort puts them in the middle of the result set (in Chrome).

Nice to know it wasn't only me!

[Hamlet]

Thanks for Your response mate. Yup. You're not alone with that issue. I don't know what's the problem. 

[Sahir]

I have a date sorting issue in  my application. Kindly help me f you can?

https://www.telerik.com/account/support-tickets/view-ticket?threadid=1056679

https://stackoverflow.com/questions/38896594/why-kendo-ui-grid-date-is-not-sorting-properly