Kendo UI Grid weird issues with sorting DateTime

Question

The Issue I am seeing is that not all the data is being sorted correctly in this instance it looks like it is ignoring the AM / PM and is sorting strictly off the numerical value of the hours minutes and seconds. I have also attached a snippet of code below is there something I need to do differently or is this possibly a Kendo UI bug

{
  title : "Start Date",
  field : "startDate",
  width : 150,
  template : "#= (startDate==null? '': kendo.toString(new Date(startDate),'MM/dd/yyyy hh:mm tt')) #",
  format : "{0: MM/dd/yyyy hh:mm tt}",
  filterable : {
                 ui : "datetimepicker"
               }
},
{
  title : "Error Date",
  field : "errorDate",
  width : 150,
  template : "#= (errorDate==null? '': kendo.toString(new Date(errorDate),'MM/dd/yyyy hh:mm tt')) #",
  format : "{0: MM/dd/yyyy hh:mm tt}",
  filterable : {
               ui : "datetimepicker"
               }
}

score 0 · Answer 1 · edited May 23 '17 at 11:51

The Kendo UI DataSource widget performs filtering and sorting over the actual values that exist in the data (i.e. not over the data's visual representation in the Grid cells).

The provided screenshot and code suggest that startDate and errorDate are not actual JavaScript Dates, otherwise there would be no need to call new Date() for them.

If these field values are not true Date objects, then they cannot be sorted as such and are probably currently sorted as strings.

The following thread provides more information on how to ensure that the DataSource holds actual JavaScript Date objects.

Why kendo Ui -grid date is not sorting properly?

Thanks I'll look into that and see if helps with my issue – Cody Anderson Aug 31 '16 at 20:00 — Cody Anderson, Aug 31 '16 at 20:00

Kendo UI Grid weird issues with sorting DateTime

1 Answers1