Problem with MySQL, Date format and DatePicker

[JC]

Hi!  
I have a problem with MySQL date format and DatePicker

I have one table in Mysql with one field : fechafinmantenimiento is datetime
in the table one register is like this : 2013-02-14 00:00:00

I have a Grid this is the code in the datasource :
fechafinmantenimiento: { type: "date", format: "MMMM-dd-yyyy" },
code in column :
{ field: "fechafinmantenimiento", title: "Finalización Tipo Mantenimiento", template: '#= kendo.toString(fechafinmantenimiento,"dd/MM/yyyy") #', width: 150},

Code DatePicker definition:
$("#cargarfechafinmantenimiento").kendoDatePicker({
  format: "MM-dd-yyyy"
})

On the Grid I see the value like this: 14/02/2013 <-Correct for me!

When I select a row on the grid, send the date value to the input form
<input id="cargarfechafinmantenimiento" name="fechafinmantenimiento" style="width:150px"/>

But in the input form I see the value like this : Thu Feb 14 2013 00:00:00 GMT+0100 (Hora estándar romance)

Only when I select another date on the widget, then show me the date format like this : 02-20-2013

What is wrong? a bug? a code? bad interpretation between mysql and kendoUI (javascript)?

Thank you

JC

[Daniel]

Hello,

I am not sure if I understand correctly this line:
When I select a row on the grid, send the date value to the input form
but if the value is set directly to the input then it will be formatted as JavaScript date. You should use the DatePicker value method to set the JavaScript date.
If this is not causing the issue then could you provide the full code you are using?

Regards,
Daniel
the Telerik team

[JC]

Hi Daniel

In this example I used the field OrderDate as fechafinmantenimiento

The logic is the same, I would like to see on the grid the field OrderDate with the format:  dd-MM-yyyy
but  when I select a row on the grid, I need put this format: "yyyy-MM-dd" on the
input value form1.OrderDate.value and form1.OrderDate_dp.value (input with DatePicker widget),
because the value of the form1.OrderDate.value used it to update a record in MySQL. (via php)

jsFiddle example

JC

[Daniel]

Hello again,

In order for the value to be formatted in the datepicker then you should use its value method to set it instead of the jQuery val method. If the value should be formatted in the text input then you could use the kendo.toString method. I update the jsFiddle sample to demonstrate both suggestions.

Regards,
Daniel
the Telerik team

[JC]

Hi Daniel

Problem resolved!

Thank you for the answer!