In JqGrid Display Date Time../Date(1352658600000)/

Question

/Date(1352658600000)/

When Display the date Date is not Display in Proper Format.

How to convert in to proper Format(dd/mm/yyyy)?

Do you want to do this on the client or the server, and which language in? — SimonGates, Nov 30 '12 at 11:18

score 6 · Answer 1 · answered Nov 30 '12 at 12:03

All you need to make the conversion is setting date formatter in jqGrid colum model:

$('#gridId').jqGrid({
    ...
    colModel: [
        ...
        { name: 'Column Name', index: 'Column Index', ..., formatter: "date", formatoptions: { newformat: "m/d/Y"} },
        ...
    ],
    ...
});

For the newformat option jqGrid supports PHP date formatting.

score 1 · Answer 2 · edited May 23 '17 at 12:24

Taken from the accepted answer here - Converting json results to a date

You need to extract the number from the string, and pass it into the Date constructor:

var x = [ {"id":1,"start":"\/Date(1238540400000)\/"}, {"id":2,"start":"\/Date(1238626800000)\/"} ];

var myDate = new Date(x[0].start.match(/\d+/)[0] * 1));

The parts are:

x[0].start                                - get the string from the JSON
x[0].start.match(/\d+/)[0]                - extract the numeric part
x[0].start.match(/\d+/)[0] * 1            - convert it to a numeric type
new Date(x[0].start.match(/\d+/)[0] * 1)) - Create a date object

In JqGrid Display Date Time../Date(1352658600000)/

2 Answers2