title: jQuery dataTables editor plugin DateTime format issue
body: <p>I'm using EF6 + MVC for a site. The dataTables editor is used for an UI. One table has a field 'StartDate'. It is a datetime type in the SQL Server.</p>
  
  <p>It works fine until when I try to edit the 'StartDate' value. From the browser debug, I can see that the JSON send from backend to UI is in the timestamp format, i.e. /Date(1541923200000)/ . </p>
  
  <p><a href="https://i.stack.imgur.com/Yvn6e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Yvn6e.png" alt="enter image description here"></a></p>
  
  <p>In the dataTables, I convert this to the correct local datetime format, so it shows correctly. </p>
  
  <p><a href="https://i.stack.imgur.com/tWgjo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tWgjo.png" alt="enter image description here"></a></p>
  
  <p>However, I could not figure out how to do this in Editor plugin. It always shows the /Date(1541923200000)/ .</p>
  
  <p>The code I use is:</p>
  
  <pre><code>editorAdvertisement = new $.fn.dataTable.Editor({
      ajax: '/APN/GetAdvertisementData',
  
      table: "#tblAdvertisements",
      fields: [{
          label: "StartDate",
          name: "AdvStartDate"
          , type: "datetime"
          , format: 'MM\/DD\/YYYY h:mm a'
      }, {
          label: "Deadline",
          name: "AdvDeadline"
          , type: "datetime"
      }, {
          label: "TitleOfAdv",
          name: "TitleOfAdv"
      }, {
          label: "ListPrice",
          name: "ListPrice"
      }
      ]
  });
  
  var tbl = $('#tblAdvertisements').DataTable({
      pageLength: 10,
      dom: '&lt;"html5buttons"B&gt;lTfgitp',
      ajax: '/APN/GetAdvertisementData'
      ,
      columns: [
          {
              data: "AdvStartDate", name: "AdvStartDate"
              , type: "datetime"
                  , render: function (value) {
                      var r = convertDate(value);
                      return r;
                  }
              , "autoWidth": true
          },
          {
              data: "AdvDeadline", name: "AdvDeadline"
              , type: "datetime"
              , render: function (value) {
                  var r = convertDate(value);
                  return r;
              }
              , "autoWidth": true
          },
          { data: "TitleOfAdv", name: "TitleOfAdv", "autoWidth": true },
          {
              data: "ListPrice", name: "ListPrice", "autoWidth": true
              , render: $.fn.dataTable.render.number(',', '.', 0, '$')
          }
      ],
      order: [1, 'asc'],
      select: {
          style: 'os',
          selector: 'td:first-child'
      },
      buttons: [
          { extend: "create", editor: editorAdvertisement }
          , { extend: "edit", editor: editorAdvertisement }
          , { extend: "remove", editor: editorAdvertisement }
  
      ]
      , select: true
      , searching: false
      , paging: false
  
  });
  </code></pre>
  
  <p>In the controller</p>
  
  <pre><code>[AcceptVerbs(HttpVerbs.Get | HttpVerbs.Post)]
  public ActionResult GetAdvertisementData()
  {
      var request = HttpContext.Request.Form;
      var settings = Properties.Settings.Default;
  
      using (var db = new Database(settings.DbType, settings.DbConnection))
      {
          var response = new Editor(db, "Advertising", new[] { "AdvertisingID" })
              .TryCatch(false)
              .Model&lt;Advertising2&gt;()
              .Field(new Field("AdvStartDate")
                  .Validator(Validation.DateFormat(
                      "MM/dd/yyyy",
                      new ValidationOpts { Message = "Please enter a date in the format MM/dd/yyyy" }
                  ))
                  .GetFormatter(Format.DateTime("yyyy-MM-dd HH:mm:ss", "MM/dd/yyyy"))
                  .SetFormatter(Format.DateTime("MM/dd/yyyy", "yyyy-MM-dd HH:mm:ss"))
              )
              .Field(new Field("AdvDeadline")
                  .Validator(Validation.DateFormat(
                      "MM/dd/yyyy",
                      new ValidationOpts { Message = "Please enter a date in the format MM/dd/yyyy" }
                  ))
                  .GetFormatter(Format.DateSqlToFormat("MM/dd/yyyy"))
                  .SetFormatter(Format.DateFormatToSql("MM/dd/yyyy"))
              )
  
              .Field(new Field("TitleOfAdv"))
              .Field(new Field("ListPrice"))
  
              .Process(request)
              .Data();
  
          return Json(response, JsonRequestBehavior.AllowGet);
      }
  }
  </code></pre>
  
  <p>I could not figure it out after a long search. Anyone had the same issue? Any solution?</p>