How to format date parsed from ASPX JSON via AJAX?

Question

Actually i'm parsing some data from MySQL then i serialize them as JSON. The next step is where i retrive the JSON via AJAX and put the data in a Chart.JS.

The issue is that the date values are formatted as

/Date(154564434687)/

Here is the JQuery code where i set the values to the chart from parsed JSON

 function GetMOV() {

        $.ajax({
            type: "post",
            url: "index.aspx/GetMOV",
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (r) {

                data = r.d;
                data = jQuery.parseJSON(data)

                new Chart(document.getElementById("linechart"), {
                    type: 'line',
                    data: {
                        labels: data.map(f => f.text),
                        datasets: [
                            {
                                label: "Venduto",
                                data: data.map(f => f.value),
                                fill: false,
                                borderColor: 'rgba(75,192,192,1)',
                                lineTension: 0.1,
                                borderWidth: 3,
                                pointBackgroundColor: '#fff',
                                pointBorderWidth: 1,
                                pointHoverRadius: 5,
                                borderCapStyle: 'square',
                                borderJoinStyle: 'square',
                                pointHitRadius: 20,
                                pointStyle: 'circle',
                            }
                        ]
                    },
                    options: {
                        legend: { display: false },
                        scales: {
                            yAxes: [{
                                ticks: {
                                    beginAtZero: true,
                                    min: 0
                                },
                                time: {
                                    unit: 'year'
                                }
                            }]
                        }
                    }
                });

            },
            error: function (error) {
                OnFailure(error);
                alert('Error');
            }
        });
    }

Possible duplicate of [How do I format a Microsoft JSON date?](https://stackoverflow.com/questions/206384/how-do-i-format-a-microsoft-json-date) — Rob, Feb 07 '19 at 14:00
@Rob i've yet tryed something like new Date(data.map(f=>f.text) it doesn't work as it's not a string — NiceToMytyuk, Feb 07 '19 at 14:02

Hien Nguyen · Accepted Answer · 2019-02-07T14:49:16.703

2

I have just tried some line of codes. Do you want like this?

var data = [{value: 4111.47, text: "/Date(1540159200000)/"} ,{value: 5122.85, text: "/Date(1540245600000)/"} ,{value: 3906.24, text: "/Date(1540332000000)/"} ,{value: 3749.79, text: "/Date(1540418400000)/"} , {value: 6349.68, text: "/Date(1540504800000)/"}];
function ToJavaScriptDate(value) {
  var pattern = /Date\(([^)]+)\)/;
  var results = pattern.exec(value);
  var dt = new Date(parseFloat(results[1]));
  return (dt.getMonth() + 1) + "/" + dt.getDate() + "/" + dt.getFullYear();
}
data.map(c=>ToJavaScriptDate(c.text))

edited Feb 07 '19 at 14:49

answered Feb 07 '19 at 14:38

Hien Nguyen

24,551
7
52
62

This is a function, can you move this function above function GetMOV()? – Hien Nguyen Feb 07 '19 at 14:42
I just was setting it to the wrong variable, that's works thank you – NiceToMytyuk Feb 07 '19 at 14:43

score 1 · Answer 2 · answered Feb 07 '19 at 13:43

1

You can use this function

function ToJavaScriptDate(value) {
  var pattern = /Date\(([^)]+)\)/;
  var results = pattern.exec(value);
  var dt = new Date(parseFloat(results[1]));
  return (dt.getMonth() + 1) + "/" + dt.getDate() + "/" + dt.getFullYear();
}

ToJavaScriptDate("/Date(154564434687)/")
"11/25/1974"

answered Feb 07 '19 at 13:43

Hien Nguyen

24,551
7
52
62

Can you put your full data here? – Hien Nguyen Feb 07 '19 at 14:29
10: {value: 4111.47, text: "/Date(1540159200000)/"} 11: {value: 5122.85, text: "/Date(1540245600000)/"} 12: {value: 3906.24, text: "/Date(1540332000000)/"} 13: {value: 3749.79, text: "/Date(1540418400000)/"} 14: {value: 6349.68, text: "/Date(1540504800000)/"} – NiceToMytyuk Feb 07 '19 at 14:30

score 1 · Answer 3 · answered Feb 07 '19 at 13:49

1

You also can use momentjs library.

var yourdate = "/Date(154564434687)/";
moment(Number(yourdate.match(/\d+/)[0])).format('MM/DD/YYYY')
"11/25/1974"

answered Feb 07 '19 at 13:49

Hien Nguyen

24,551
7
52
62

There is just a problem i have an array with a lot of data not a single string – NiceToMytyuk Feb 07 '19 at 13:50

How to format date parsed from ASPX JSON via AJAX?

3 Answers3