dateformat

[wpdParticipant]

i am trying to show the date in my grid in 24hr format but the grid is showing in different format
here is my code

var data = ‘[{“date”: “1988-05-23T12:05:21Z”}]’;
// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘date’, type: ‘date’ }
],
localdata: data
};
var dataAdapter = new $.jqx.dataAdapter(source);
$(“#jqxgrid”).jqxGrid(
{
width: 300,
source: dataAdapter,
columns: [
{ text: ‘date’, datafield: ‘date’, cellsformat: ‘dd.MM.yyyy HH:mm:ss’ }
]
});

outcome is 23.05.1988 08:05:21
i am not sure in which format it is displaying can you explain about this.
and i also what to display the time in 23.05.1988 12:05:21 can you let me know who i can do this

[StanislavParticipant]

Hello wpd,

You can read more about the date-format in our Grid ARI:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/gridcellclass.htm

Go to ‘columns’, and then go to ‘cellsformat – sets the formatting of the grid cells’. You should find helpful information there.

The outcome of your example is ‘23.05.1988 15:05:21’.

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[wpdParticipant]

Thank you.

But I want to display the date as 23.05.1988 12:05:21 on the grid can you please let me know how i can do this.

[wpdParticipant]

Here is the solution

var data = ‘[{“date”: “1988-05-23T12:05:21Z”}]’;
// prepare the data
var source =
{
datatype: “json”,
datafields: [
// you can set pattern that will match with the received data
{ name: ‘date’, type: ‘date’, format: ‘yyyy-MM-ddTHH:mm:ssZ’ }
],
localdata: data
};
var dataAdapter = new $.jqx.dataAdapter(source);

$(“#jqxgrid”).jqxGrid(
{
width: 350,
source: dataAdapter,
columns: [
{
text: ‘date’, datafield: ‘date’, cellsformat: ‘dd.MM.yyyy HH:mm:ss’
}
]
});

outcome:23.05.1988 12:05:21

[Author]

Posts