Convert grid filter date field to UTC

Progress® Kendo UI® for jQuery Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Unplanned

Last Updated: 03 Nov 2022 09:27 by ADMIN

SAM

Created on: 02 Oct 2019 11:22

Category: Data Source

Type: Feature Request

Convert grid filter date field to UTC

When the grid is configured for working with UTC on the server-side, the value sent from the filter menu on the client-side would not be properly sent to the server.

If the stringifyDates option of the transport of the data source is set, the value would still be sent in a localized date format without information for the time zone, for instance, GMT(+0300).

In case the value sent from the client is modified, the parameterMap would be called afterward and would override the modified value.

Moreover, the Kendo UI Binder on the server-side is not configured to be working with dates that have additional data for the time zone appended to the end. Therefore, sending the modified data would not be parsed correctly and FormatException error would be thrown.

4 comments

ADMIN

Georgi Denchev

Posted on: 03 Nov 2022 09:27

Hello, Jyotika,

Could you take a look at the discussion in the following feedback item:

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

Here's a link to the proposed solution:

https://docs.telerik.com/aspnet-mvc/knowledge-base/datetimepicker-datetimeoffset-bind-to-model

The reason why there isn't a built-in functionality is described in the above thread:

While researching the issue we found that there is no one-size-fits-all solution. If we were to add this as a built-in feature the dates had to be forced to use a very specific format. However, this would not work for everyone as we are aiming to make the components usable in various scenarios. Because of this the recommended approach is to use AutoMapper. That would enable you to use the date format that works best in your scenario.

Best Regards,
Georgi Denchev
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jyotika

Posted on: 27 Oct 2022 13:56

Any progress on this request? In current version also we are facing similar issue

ADMIN

Alex Hajigeorgieva

Posted on: 28 Apr 2020 07:28

Hi,

We have a very popular item for DateTimeOffset binding which will requires us to implement changes both on the client picker binders and also in the server-side extensions.

As we are gathering more information for it, could you take a look at that thread and add your take on it so it can be considered before implementation begins:

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

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.

Leo

Posted on: 21 Apr 2020 13:32

Really need proper datetime data exchange between client and server. With the current implementation neither side knows the others timezone. The so called workarounds lead to cluttered code, introducing bugs and still keep some problems unsolved.