Datetime format in column of Grid

[Bertha]

I am using api with json to get the date.  With the attached code, I can get the date in correct format in Grid column but the time is always 12:00.  How can I fix that.

            { field: "RequestedDate", title: "Requested Date", width: "150px", type:"datetime", template: "#= kendo.toString(kendo.parseDate(RequestedDate, 'yyyy-MM-dd'), 'dd MMM yyyy hh:mm') #" },


Thanks.

[Alexander Valchev]

Hi Bertha,

What is the raw value of RequestedDate? It might be possible that the format is not recognized by kendo.parseDate.

Regards,
Alexander Valchev
Telerik

 

 

[Bertha]

The format is from web api.  so, it is "2014-07-22T14:58:27.683".
How can I make it work?  Thanks.

[Alexander Valchev]

Hi Bertha,

Thank you for the additional information.

In order to fix the issue please change the template to:

template: "#= kendo.toString(kendo.parseDate(RequestedDate), 'dd MMM yyyy hh:mm') #"

On a side note, the RequestedDate should be already parsed as date. It seems that in your case it is not, please check if the field is set to type: "date" in the dataSource.schema.model.fields configuration.
Once it is set to type date the dataSource automatically parse and the template will be simplified to:

template: "#= kendo.toString(RequestedDate, 'dd MMM yyyy hh:mm') #"

I hope this information will help.

Regards,
Alexander Valchev
Telerik

 

 

[Bertha]

Thanks.

I mark it as datetime.  After I changed it to date, the time shows properly.

   RequestedDate: { nullable: false, type: "datetime" },

[Paolo]

Hi

 

what is the default format recognized from the kendo datetime parser for columns of type date ? in many examples I see 2014-07-22T14:58:27 ?

 

More simply, I need to change server response format to adhere at a recognized format, where is documented the right format so I can only specify schema.model.field.type == date without needing more code ?

 

 

[Konstantin Dikov]

Hi Paolo,

The date format depends on the current culture. More information on this matter could be found in the following help article:

• http://docs.telerik.com/kendo-ui/framework/globalization/dateparsing

Best Regards,
Konstantin Dikov
Telerik by Progress

[Paolo]

Thanks Konstantin, I will try