Date format is not being correctly detected

justSteve

I have a data coming from the server where a date column is of form: 1/25/2015 12:45:10 AM but is rendered in the table as /Date(1422168310723)/

I've implemented the Moment plug in and believe I'm correctly initializing because inserting debug alert:

    $.fn.dataTable.moment = function (format, locale) {
        alert(format);

will return 'M/D/YYYY'.

My ajax:

            "ajax": {
                "type": "POST",
                "url": '/admin/UsersDataHandler',
                "contentType": 'application/json; charset=utf-8',
                'data': function (data) {
                    data.affiliateId = DU.affiliateId;
                    return data = JSON.stringify(data);
                }

serverSide and processing both set to true;

To keep it simple, i'm not currently posting an entry for the column in "aoColumnDefs": and only use { 'data': 'DateCreated', "searchable": false } in the "columns" collection.

Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

allan

Can you link to the page showing the issue please. I don't quite understand why DataTables would show a Microsoft date format if the server-side is actually returning a sensible date string.

Allan

justSteve

I tweaked my server-side code with: OrderDate.ToShortDateString(); and the problem resolved. Thanks