Grid client template and date formats

[Dima]

Hi,

How can I  format my date to MM/dd/yyyy in client template? It seems that Format method doesn't work for client templates. Also, I need to sort column that contains date.

Thanks in advance,
Dzmitry Shmidt

[Nikolay Rusev]

Hello Dzmitry,

When using template the formation must be handled within the template. For example:

{
 field: "BirthDate",
 title: "Birth Date",
 template: '#= kendo.toString(BirthDate,"dd/MM/yyyy") #'
}

You can find more details by inspecting the code in the following demo:
http://demos.kendoui.com/web/grid/index.html
http://docs.kendoui.com/getting-started/framework/globalization/dateformatting
All the best,
Nikolay Rusev
the Telerik team

[Dima]

Thanks Nikolay for you reply,
Sorry but i didn't mention, that i used asp.net mvc and want to write as little javascript code as possible. Now when i used date time it's displayed as /Date(.......)/ format. Is there any way to do this on the server and don't use javascript.

Thanks in advance,
Dzmitry Shmidt

[Nikolay Rusev]

Hello Dzmitry,

If you describe the fields in the DataSource.schema and mark them with correct types it will automatically convert those values to correct JavaScript types. For more details see the configuration for the date field in the following demo:
http://demos.kendoui.com/web/grid/remote-data.html

Regards,
Nikolay Rusev
the Telerik team

[Raimundo]

Nikolay if we use CLIENTTEMPLATE, with AJAX, your answer (http://demos.kendoui.com/web/grid/remote-data.html) doesn't fix the problem.

Could you provide some code about it, with Razor?

[Raimundo]

Nikolay if we use CLIENTTEMPLATE, with AJAX, your answer (http://demos.kendoui.com/web/grid/remote-data.html) doesn't fix the problem.

Could you provide some code about it, with Razor?

For instance:

.ClientTemplate(
string.Format("<spam style='background-color: green; text-align:right;'>{0:yyyy}}</spam>", "#:ShipDate#")
);

[Kiril Nikolov]

Hello Raimundo,

What my colleague suggested is to set the type of the data that you get from the server to be date, so the Grid will know to parse the data to valid JavaScript objects. How to define a model is explained here:

http://docs.telerik.com/kendo-ui/api/javascript/data/model#configuration-Define

If this does not help, please send us a send a runnable sample and we will be happy to help.

Regards,
Kiril Nikolov
Telerik

 

 

[Imran]

This thing worked for me good

 

c.Bound(p => p.datetimecalculated).Format("{0:dd-MM-yyyy}");​