title: Format Date inside jQuery datatable
body: <p>I am using jQuery datatables to display sms statistics on my web app, the datatable is used for ease of paging, search and sorting functionalities which works fine. However ene of the columns on the data table is a date,here is my action method that returns the json object</p>
  
  <pre><code> public ActionResult LoadStatistics(jQueryDataTableParamModel param)
      {
          //jQueryDataTableParamModel param = new jQueryDataTableParamModel();
          var allStats = _dbManager.GetSMSStatitistics();
          var filteredStats = allStats;
          if (!string.IsNullOrWhiteSpace(param.sSearch))
          {
              filteredStats = filteredStats.Where(x =&gt; x.StaffNameF.Contains(param.sSearch, false)
                                              || x.StaffNameS.Contains(param.sSearch, false)
                                              || x.SiteID.Contains(param.sSearch, false)).ToList();
          }
          return Json(new
          {
              iTotalRecords = allStats.Count(),
              iTotalDisplayRecords = filteredStats.Count(),
              aaData = filteredStats
          }, JsonRequestBehavior.AllowGet);
      }
  </code></pre>
  
  <p>Now in the view I have the following piece of code,to load data into my table,</p>
  
  <pre><code>@section scripts
  </code></pre>
  
  <p>{
      
      
      </p>
  
  <pre><code>&lt;script type="text/javascript"&gt;
  
      $(function () {
          $('#statsTable').dataTable({
              bProcessing: true,
              bServerSide: false,
              bPaginate: true,
              sAjaxSource: '@Url.Action("LoadStatistics", "Statistics")',
              "aoColumnDefs": [
                  { "aTargets": [0], "mData": 'StaffNameF' },
                  { "aTargets": [1], "mData": 'StaffNameS' },
                  { "aTargets": [2], "mData": 'StaffEmail', "sWidth": "300px" },
                  { "aTargets": [3], "mData": 'SiteID' },
                  { "aTargets": [4], "mData": 'DateTimeIn', "sWidth": "300px", "sFormat": "dd/MM/YYYY" },
                  { "aTargets": [5], "mData": 'CellNumber' }]
          });
      });
  
  &lt;/script&gt;
  </code></pre>
  
  <p>This is working fine for all the columns, except the date which displays something like this "/Date(1488924000000)/". I am assuming this is the date but it just needs formatting, how can I achieve this, I have tried "sFormat": "dd/MM/YYYY" but no luck, I have no clue how to do this inside the table.</p>