Formatting a DateTimeOffset

[Garee]

Hi,

I have some values that are DateTimeOffsets. I'm having trouble formatting them in a grid though.

This code:

columns.Bound(c => c.StartTimestamp).Width(750).Format("{0:dd/MM/yyyy HH:mm:ss}");

produces:

2019-06-06T17:47:52.0256922+01:00

when what I want to see is:

06/06/2019 17:47:52

Is the Grid unable to format DateTimeOffsets, or am I missing something?

Thanks,

Gary

[Alex Hajigeorgieva]

Hello, Gary,

The DateTimeOffset does not get serialized to a type date in the data source schema model, therefore the format will not take effect. You can use a ClientTemplate instead:

columns.Bound(c => c.StartTimestamp).Width(750)..ClientTemplate("#=kendo.toString(kendo.parseDate(StartTimestamp), 'dd/MM/yyyy HH:mm:ss')#");

https://docs.telerik.com/kendo-ui/globalization/intl/dateparsing

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[Garee]

Thanks Alex - that's perfect.

Thanks also for the links to the documentation on this - that's what I was struggling to find.

Cheers,

Gary

[Alex Hajigeorgieva]

Hi, Gary,

There is another way that the same can be achieved so I wanted to update the thread.

One can trick the grid that the DateTimeOffset field is a DateTime field by setting its type in the DataSource Schema Model. Then the Format will work and the ClientTemplate will become redundant:

 .Model(model =>
{
      model.Field("StartTimestamp", typeof(DateTime));
 })

columns.Bound(c => c.StartTimestamp).Format("{0:dd/MM/yyyy HH:mm:ss}");

Kind Regards,
Alex Hajigeorgieva
Progress Telerik