Incorrect date on return of json

Question

Good afternoon,

Json’s return brings the badly formatted date = "/Date(1420077600000)/", how to treat ?

{"TB1":1,"DTADMISSAO":"\/Date(1420077600000)\/"}

This is the section where the Data field:

$.ajax({
                        url: "ObterFuncionario",
                        type: "post",
                        datatype: "json",
                        contentType: "application/json charset=utf-8",
                        data: JSON.stringify({ "id": id }),
                        processData: false,
                        beforeSend: function () {
                            $("#divCarregando").show();
                        },
                        complete: function () {
                            $("#divCarregando").hide();
                        },
                        success: function (data) {
                            $("#DTADMISSAO").val(data.DTADMISSAO);    
                        },
                        error: function (result) {
                            alert(result.responseText);
                        }
                    });

HTML:

<div class="form-group small">
                        <div class="col-sm-2">
                            ADMISSÃO:
                        </div>
                        <div class="col-sm-10">
                            <input type="text" id="DTADMISSAO" class="form-control input-sm" />
                        </div>
                    </div>

Answer 1

On the return of your date you can convert it to ToShortDateString, ai in your ajax’s Success it already comes formatted

Example:

DateTime.Now.ToShortDateString();

Answer 2

This value that is within Date() is the number of milliseconds since midnight on January 1, 1970.

You can convert to Data again by creating a new date with this value:

function retornaData(valor){
    var dataAdmissao = valor;
    var milisegundos = parseInt(dataAdmissao.slice(dataAdmissao.indexOf('(') + 1, dataAdmissao.indexOf(')')));
    var data = new Date(milisegundos);

    return (("0" + (data.getMonth() + 1)).slice(-2) + "/" +  ("0" + (data.getDate())).slice(-2) + "/" + data.getFullYear())
}

Use:

$("#DTADMISSAO").val(retornaData(data.DTADMISSAO));

Example: https://jsfiddle.net/g5n300ud/1/

References: Date.prototype.getTime(), getTime (Date) (Javascript)

Answer 3

It has this "contour solution".

var dataAdmissao = obj.DTADMISSAO
var milisegundos = parseInt(dataAdmissao.slice(dataAdmissao.indexOf('(') + 1, dataAdmissao.indexOf(')')));
var data = new Date(milisegundos);

Surely there’s some much better way to do it.

If you can’t find a solution, maybe it’ll do.

Answer 4

Make this change on Controller return

Example:

public ActionResult RetornarData([DataSourceRequest] DataSourceRequest request) {
  DateTime data=DateTime.Now;
  return Json(data.ToString(), JsonRequestBehavior.AllowGet);
}