Working with json dates

[fmcorreiaMember]

Hi,

How can we format a JSON date to render in a certain format?

if I set the cellsformat with ‘dd-MM-yyyy HH:mm’ it display the value as it is (in json format).

What am i missing?

Best Regards,

Francisco Correia

[Peter StoevKeymaster]

Hi Francisco,

Do you set the ‘date’ type in the data field initialization?

Sample:

     var source =
            {
                datatype: "xml",
                datafields: [
                    { name: 'ShippedDate', map: 'm\\:properties>d\\:ShippedDate', type: 'date' },
                    { name: 'Freight', map: 'm\\:properties>d\\:Freight', type: 'float' },
                    { name: 'ShipName', map: 'm\\:properties>d\\:ShipName' },
                    { name: 'ShipAddress', map: 'm\\:properties>d\\:ShipAddress' },
                    { name: 'ShipCity', map: 'm\\:properties>d\\:ShipCity' },
                    { name: 'ShipCountry', map: 'm\\:properties>d\\:ShipCountry' }
                ],
                root: "entry",
                record: "content",
                id: 'm\\:properties>d\\:OrderID',
                url: url
            };

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[fmcorreiaMember]

Hi,

I receive this information through a ajax request to the webservice, is mandatory to define the source structure this way to render the date? I already define the columns using the answer properties in the grid, I would like to set the source with the ajax request answer and not “redefine” the columns.

[Peter StoevKeymaster]

Hi fmcorreia,

It is important to define the datafields and set the ‘type’ of each datafield which is not string.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts