Sending date time with Ajax

[daddetimParticipant]

Hi all,
i am using a basic configuration of jqxgrid. I have a date time field

{ text: \’DATA CRM\’, datafield: \’data_crm\’, columntype: \’datetimeinput\’, width: 100, cellsformat: \’d\’},

I see in the cell the value in the format: “22/09/2014”

but when i send the value of the raw via an ajax xhr i obtain in the server the extended format:
“Wed Oct 22 2014 00:00:00 GMT 0200 (W. Europe Daylight Time)”

How can i send only the date in the format: GG/MM/AAAA ? I need to put it in a mysql field DATE

This is the Ajax section of the code:

…
updaterow: function (rowid, rowdata, commit) {
// synchronize with the server – send update command
var data = “update=true&data_crm=” + rowdata.data_crm;
$.ajax({
dataType: \’json\’,
url: \’asset.php\’,
data: data,
success: function (data, status, xhr) {
if ( data == “1” ) {
// update OK
commit(true);
});
} else
{
alert(“Error”);
};
}
}); `

Thank you all
bye

[DimitarParticipant]

Hello daddetim,

You can try the following change:

var data = “update=true&data_crm=” + $.jqx.dataFormat.formatdate(rowdata.data_crm, "d");

Best Regards,
Dimitar

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

[Author]

Posts