Need More Info
Last Updated: 02 Mar 2020 15:10 by ADMIN
Greg
Created on: 17 Feb 2020 22:17
Category: Grid
Type: Feature Request
4
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.
3 comments
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.