Allow simple option in grid to turn off automatic timezone correction in order to display dates from server

Progress® Telerik® UI for ASP.NET MVC Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 01 Jul 2021 14:12 by ADMIN

Greg

Created on: 17 Feb 2020 22:17

Category: Grid

Type: Feature Request

Allow simple option in grid to turn off automatic timezone correction in order to display dates from server

We need to always display dates to the client in EST. We do not store our dates in SQL server as UTC but instead in local EST by default (for a number of different reasons. A simple option in the grid (and other controls for that matter) to ignore the automatic conversion process would be *Very* helpful. I have seen lot's of posts in different sites asking for this option. Thank you.

4 comments

ADMIN

Viktor Tachev

Posted on: 01 Jul 2021 14:12

Hello,

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

Regards,
Viktor Tachev
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

ADMIN

Alex Hajigeorgieva

Posted on: 02 Mar 2020 15:10

Hi, Greg,

Thank you for your feedback. I have passed it on to our product managers.

I believe that the DateTimeOffset type will be able to deliver the required functionality as we need to know what is the timezone that the dates should offset to from the JavaScript dates that the browser automatically creates with local offset.

Hopefully, due to the popularity of the item, it should not be too long before we start working on it.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

Get quickly onboarded and successful with your Telerik UI for ASP.NET MVC with the dedicated Virtual Classroom technical training, available to all active customers.

Greg

Posted on: 24 Feb 2020 21:59

Hi Alex, thanks for the reply!

Yes, being able to bind to specific DateTimeOffset in the Date/DateTime picker I believe would be helpful.

In our case we would also love to be able to 'turn off' or set an option on the grid (by column/field if possible) to not automatically recalculate DateTimes for local offset as well.

As I mentioned we need all dates to display as we send them from our server as we are supplying time sensitive EST shipping date to our clients.

Any control that gives you more options in this regard is ultimately more flexible and requires less custom client scripting.

Greg

ADMIN

Alex Hajigeorgieva

Posted on: 24 Feb 2020 09:24

Hello, Greg,

Thank you for the suggestion.

Indeed there are quite a few suggestions which we have received when dealing with dates and your post has come to us in the right time frame as we are trying to crystalize the idea and understand which of the options that others have submitted would have the most positive impact and help accelerate the development time.

I believe that if we were to introduce DateTimeOffset binding, that would allow you to accomplish your requirement as this very popular item suggests:

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

We would appreciate it if you have a look at this and let us know what your thoughts are on this. Alternatively, this could be the other feature that might solve your current requirement:

https://feedback.telerik.com/kendo-jquery-ui/1359348-add-ability-to-disable-daylight-savings-or-specify-timezone-on-datetimepicker

Look forward to hearing back from you - here and also in the original items if you have a moment.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

Get quickly onboarded and successful with your Telerik UI for ASP.NET MVC with the dedicated Virtual Classroom technical training, available to all active customers.