[sspParticipant]

Hi Peter,

As I am facing the same problem with Timestamp displaying,

I tried your above example, but if the width of the “Ship Date” is increased to 150, I still could see timestamp being displayed in the grid cell….

what may be the reason??

Thanks & Regards,

ssp

[sspParticipant]

Hi,,

I have to obtain the date value from the database which is given in the format YYYY-MM-DD and display in the jqxgrid in the same format,,,

I have used the following code:

text : ‘Start Date’, id: ‘startDatePopUp’,datafield : ‘startDate’, columntype: ‘datetimeinput’, cellsformat: YYYY-MM-DD’, align : ‘center’, width : 150, cellsalign : ‘center’,

but it is being displayed in the grid as YYYY-MM-DD 00:00:00.0

how will I display the date value in the format YYYY-MM-DD in the jqxgrid??

Thanks & Regards,

ssp

[sspParticipant]

Hi,

How to display Date in the grid cell in the format YYYY-MM-DD?

because in ,
text : ‘Start Date’, id: ‘startDatePopUp’,datafield : ‘startDate’, columntype: ‘date’, cellsformat: ‘yyyy-MM-dd’, align : ‘center’, width : 150, cellsalign : ‘center’,

the cellFormat doesn’t work for any of the formats in the grid other than the YYYY-MM-DD 00:00:00.0

Thanks & Regards,

ssp

[sspParticipant]

Hi,

Sorry I forgot to mention, though I am initializing the property of Date column as type: ‘date’,
I am not able to remove the timestamp values from the Date : YYYY-MM-DD 00:00:00.0

I have set the datafields initialization in the following way,

var milestone =
{
datatype: “json”,
datafields: [
{ name: ‘milestoneType’, type: ‘string’},
{ name: ‘phase’, type: ‘string’},
{ name: ‘phaseDescription’, type: ‘string’},
{ name: ‘customPhase’, type: ‘string’},
{ name: ‘startDate’, type: ‘date’},
{ name: ‘endDate’, type: ‘date’}

],
cache: false,
url: ‘milestoneJCI.htm’

};

.
.
.
initeditor: function (row, cellvalue, editor) {
editor.jqxDateTimeInput(‘setDate’, new Date());
}

Please let me know how can I display only the Date in the grid in the format : YYYY:MM:DD ???

Thanks & Regards,

ssp

[sspParticipant]

Hi,

I have set the datafields initialization in the following way,

var milestone =
{
datatype: “json”,
datafields: [
{ name: ‘milestoneType’, type: ‘string’},
{ name: ‘phase’, type: ‘string’},
{ name: ‘phaseDescription’, type: ‘string’},
{ name: ‘customPhase’, type: ‘string’},
{ name: ‘startDate’, type: ‘date’},
{ name: ‘endDate’, type: ‘date’}

],
cache: false,
url: ‘milestoneJCI.htm’

};

.
.
.
initeditor: function (row, cellvalue, editor) {
editor.jqxDateTimeInput(‘setDate’, new Date());
}

Thanks & Regards,

ssp

[sspParticipant]

Hi,

I get the same display format i.e. YYYY-MM-DD 00:00:00.0 even after changing the cellsformat:

text : ‘Start Date’, id: ‘startDatePopUp’,datafield : ‘startDate’, columntype: ‘date’, cellsformat: ‘yyyy-MM-dd’, align : ‘center’, width : 150, cellsalign : ‘center’,

tried with both columntype: ‘date’ and columntype: ‘datetimeinput’

Do you mean datafields array initialization in the database:
in my oracle db, the initialization is Date and is in the Date format only without having any time values….

Thanks & Regards,

ssp

[sspParticipant]

Oh I am able to export the grid now!!
Thanks a lot!!

[sspParticipant]

Thank you so much for the reply Peter!!

[sspParticipant]

Peter,

Thanks for all the replies!!

I was able to export the grid a couple of times with OPEN and SAVE options, even though it was redirecting to the page:”http://jquerygrid.net/export_server/save-file.php” most of the times,.so I assume there was no security restrictions,
But today I am unable to export even once,
please help me out with this strange output!

[sspParticipant]

Hi Peter,

I do not have any save-file.php and for information I use Java Spring MVC framework,
plz give me the solution for not being able to export??

Thanks,

[sspParticipant]

Hi,

I am trying to export a jqxgrid to excel using the following function:

$(“#excelExport1”).click(function () {
$(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, ‘jqxGrid’,false);
});

On clicking the export button it is navigating to “Internet Explorer cannot diaplay a webpage” with the url

http://jquerygrid.net/export_server/save-file.php

[Author]

Posts