title: Filtering/Sorting a DateTime column in Kendo Grid
body: <p>I have a datetime column in my Kendo Grid. The values look like this: <code>2014-04-11 12:43:41.720</code></p>
  
  <p>In my grid, I have changed the template to just display them as short dates: <code>04/11/2014</code></p>
  
  <p>The reason I don't just send data to the columns preformatted is because I want the time to be taken into account for sorting. My problem now is that when filtering, specifically when doing an "equal to" filter, if I select <code>4/11/2014</code> from the datepicker, it will not show any results because the time is by default <code>12:00:00.00</code>.</p>
  
  <p>Is there anyway I can filter based on the text instead of the value? Or can I send preformatted dates to the grid and have the sort use a different field?</p>
  
  <p>JS snippet of my column:</p>
  
  <pre><code>columns: [
      { 
        field: "CREATEDATE",
        title: "Created",
        width: 78,
        template: '#= kendo.toString(kendo.parseDate(CREATEDATE, "yyyy-MM-dd"), "MM/dd/yyyy") #',
        filterable: true,
        attributes: { style: "text-align:center;" }
      }
  ]
  </code></pre>