Hi Logan,

When binding to DateTimeOffset you can utilize AutoMapper library or custom mapper to bind the values and show them in the Grid. The example and the knowledge base articles illustrate the approach with AutoMapper.

Regards,
Viktor Tachev
Progress Telerik

Hi Levi,

We did not add a built-in feature for DateTimeOffset due to some limitations in .NET Framework.

We could add an overload for our pickers that accepts DateTimeOffset and displays it. However, submitting it to the server would not be trivial. The default MVC binder is capable of binding a DateTimeOffset only if the submitted parameter is in the 2017-04-17T05:04:18.070Z format.

If we implement DateTimeOffsetoverload for the pickers we would have to either limit our clients to use only the above format or they would need to implement their own binder which can impact the whole project. 

Because of this we provided examples that illustrate how DateTimeOffset can be used with our components.

Regards,
Viktor Tachev
Progress Telerik

Hello,

We have prepared an example illustrating how DateTimeOffset values can be handled.

Knowledge Base

Example

Regards,
Viktor Tachev
Progress Telerik

Hi, Dave,

The Kendo UI Grid for ASP.NET MVC works with DateTime out of the box, it does not work with DateTimeOffset. Therefore I have changed this to a feature request so people can upvote it. We actually have one like this for the DateTimePicker and I have cast a vote for it on your behalf:

https://feedback.telerik.com/kendo-jquery-ui/1358428-support-binding-of-datetimepicker-to-type-datetimeoffset

However, it is possible to make the DateTimeOffset properties behave like a date in the grid -  e.g. you can use the columns format instead of template and get the built-in filter menu with date pickers for the column. To do this you should trick the grid by using the model and by specifying the type manually:

 .Model(m=> {
        m.Field("OrderDate", typeof(DateTime));
    });

If you have server operations enabled (they are enabled by default), you will need to "translate" the DateTimeOffset to a date here too, before passing it to the ToDataSourceResult() to execute the query:

public ActionResult Orders_Read([DataSourceRequest] DataSourceRequest request)
        {
            ModifyFilters(request.Filters);
            return Json(orders.ToDataSourceResult(request));
        }

        private void ModifyFilters(IEnumerable<IFilterDescriptor> filters)
        {
            if (filters.Any())
            {
                foreach (var filter in filters)
                {
                    var descriptor = filter as FilterDescriptor;
                    if (descriptor != null && descriptor.Member == "OrderDate")
                    {
                       // use this if using just dates
                        descriptor.Member = "OrderDate.Date";
                    }
                    if (descriptor != null && descriptor.Member == "OrderDateWithMinutes")
                    {
                        // use this if time is necessary
                        descriptor.Member = "OrderDateWithMinutes.DateTime";
                    }
                    else if (filter is CompositeFilterDescriptor)
                    {
                        ModifyFilters(((CompositeFilterDescriptor)filter).FilterDescriptors);
                    }
                }
            }
        }

Let me know in case you have further questions.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik