I also have this date formatting problem as a result of my Json data.

jsonData[0].TradeDate looks like this when I use debugger : TradeDate = "/Date(-62135578800000)/"

and in my Grid's columns def, I have :

columns: [

{ headerText: "Account", key: "Account", dataType: "string" },

 { headerText: "Trade Date", key: "TradeDate", dataType: "date", format: "MMM-dd-yy" },

]

but my TradeDate appears as "Jan01-01" .

How can I solve this one ?

thanks.

Bob

Hello Olivier,

I am just following up to see if you need any further assistance with this matter.

Hello Olivier,

Thank you for the follow up. igGrid uses the Microsoft convention which looks like "/Date(1359652468774000)/"  to format dates.

If you want igGrid to understand your date field in the JSON you should have string in the format "\/Date(1359652468774)\/" or an instance of JavaScript Date object ( like var mydate = new Date(31/12/2004);)

I hope this helps.

Any idea to accomplish this ?

Thanks,
Olivier

Hello,

My issue is the data source format and not the display. I get a json array which contains a field "CreationDate" with the following format "dd/MM/yyyy" and this is not properly processed by the grid. I'd like to know if it is possible to define the input format.

Thank you for your help,

Olivier