Datetime from json result

[wickstargazer]

Hi, i am using bbgrid in c# MVC development.
The problem i get is, the Date(xxxx) the json data gets back from the server is not rendered as date in the grid.

I am trying to find a way to solve it.

By the way, i have added a couple of events in the bbgrid code, like such

       ContentListGrid.bind('sort', function (event) {
            //console.log(event);
            $('.confirm-delete').on('click', enableDeleteButton);
        });
        ContentListGrid.bind('aftersort', function () {
            $('.star').on('click', onHighlight);
            $('.confirm-delete').on('click', enableDeleteButton);
        });
        ContentListGrid.bind('afterfilter', function () {
            $('.star').on('click', onHighlight);
            $('.confirm-delete').on('click', enableDeleteButton);
        });
        ContentListGrid.bind('afterpageChanged', function () {
            $('.star').on('click', onHighlight);
            $('.confirm-delete').on('click', enableDeleteButton);
        });

to help sustain some events after the page changes or sorting is commenced.
If you would like me to submit up to branch, will do so :)

[wickstargazer]

This is how i solved it in the render function

switch (col.type) {
case 'date':
var value = self.getPropByStr(self.model.attributes, col.name);
if (value) {
var regex = /-?\d+/;
var m = regex.exec(value);
var datetimeValue = new Date(parseInt(m[0]));
if (col.dateformat) {
//datetimeValue.format(col.dateformat);
}
col.value = datetimeValue;
}
break;
default:
col.value = self.getPropByStr(self.model.attributes, col.name);
break;
}

putting this into the config for column

{ title: 'Published Date', name: 'PublishedOn', index: true, sorttype: 'date', type: 'date', dateformat: 'dd/m/yy' }

[wickstargazer]

Lastly for the formatting

if (col.dateformat) {
if (!$.datepicker)
throw new Error("Cannot format date, please include jquery datepicker, column name : " + col.name );
datetimeValue = $.datepicker.formatDate(col.dateformat, datetimeValue);
}