title: Why kendo Ui -grid date is not sorting properly?
body: <p><strong>value is ReinsDepositAmount</strong></p>
  
  <p><a href="https://i.stack.imgur.com/WnR3b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WnR3b.png" alt="enter image description here"></a></p>
  
  <p>**</p>
  
  <h2>output</h2>
  
  <p>**</p>
  
  <p><a href="https://i.stack.imgur.com/e1EAO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e1EAO.png" alt="enter image description here"></a></p>
  
  <p>I have recently stocked with one of the application date sorting in the kendo UI grid.</p>
  
  <p>In kendo grid, the column name is defined like this</p>
  
  <p>Incoming value to <code>ReinsDepositDate</code> - Month,date,year format. 08-23-1991</p>
  
  <p><strong>Field name is ReinsDepositDate:</strong></p>
  
  <pre><code>{
      field: "ReinsDepositDate", type: "date", title: "Due Date",format: "{0:M/d/yyyy}", width: 100, filterable: {
                cell: {
                     operator: "contains"  
                      }
              }
  },
  
  </code></pre>
  
  <p>When Sorting the date, its sorting based on first values </p>
  
  <ol>
  <li>1/12/1994 </li>
  <li>23/1/2015</li>
  <li>13/1/1992</li>
  </ol>
  
  <p>means while ascending I am getting</p>
  
  <ol>
  <li>1/12/1994 </li>
  <li>13/1/1992 </li>
  <li>23/1/2015</li>
  </ol>
  
  <p>So I have put the schema model </p>
  
  <p>still, I am getting the same result.</p>
  
  <pre><code> schema: {
                  model: {
                      fields: {
                          ReinsDepositDate: { type: "date",format: "{0:dd/MM/yyyy}"}
                      }
                  }
              },
  </code></pre>
  
  <p>I have seen lots of fiddle demos nothing works here why:</p>
  
  <p>Refrences:
  <a href="http://fiddle.jshell.net/NqrDS/light/" rel="nofollow noreferrer">http://fiddle.jshell.net/NqrDS/light/</a>
  <a href="https://stackoverflow.com/questions/17564940/kendo-grid-date-column-not-formatting">Kendo grid date column not formatting</a></p>
  
  <p>Flow of Design:</p>
  
  <p>Flow of design is by using angular Http service get the value from DB through API and assign the response to datasource in the kendo grid. when I doing a demo with JSON files, its working fine. But the same thing applies it here means not working. so I went to custom javascript to sort. columns:<strong>[$scope.grdPrmiumDepositCol, –</strong> </p>
  
  <p>Custom javascript in kendo sortable attribute will do the trick.
  working fine do this part.</p>
  
  <pre><code> { field: "ReinsDepositDate", format: "{0:MM/dd/yyyy}",type:"date",  sortable:{  compare: function (a, b) {
                             var c = new Date(a.ReinsDepositDate);
                              var d = new Date(b.ReinsDepositDate);
                              return c - d;
                          }`
  
                      }}],
  </code></pre>
  
  <p>My Question is why I do that because kendo is given the date format and when I tried the sample demo with transport read with JSON file working fine with kendo format. Still in confusion.</p>