We have a date column displayed in a igGrid which is bound to a DateTime property in the model. One hour is being added to certain date values based on Daylight Savings. How to disable this adjustment. We want to display the values that is returned by the database as is. For example 12/30/2016 10:45:11 displays as 12/30/2016 11:45:11.
Hello Shashikumar,
Thank you for posting in our community.
Please try setting the enableUTCDates option to true. This option enables formatting of the dates as UTC.
//Initialize
$(
".selector"
).igGrid({
enableUTCDates :
true
});
Try this approach on your side and let me know what is the result.Additionally, a topic about Using IgniteUI controls in different time zones can be found online:https://www.igniteui.com/help/using-igniteui-controls-in-different-time-zonesDo not hesitate to contact me if you have any additional questions regarding this matter.
Hello,
We already tried it. It does not make any difference. The datetime object in the model has Kind=Unknown. We want to deal with local times only. We want to just display whatever is stored in the database as is. Our tests have revealed that one hour is added to dates that are in the daylight savings time. We are using Infragistics.Web.Mvc version 4.14.2.2081 runtime version v4.0.30319
Thank you for providing me this information.
I will investigate this matter further and I will get back to you soon with more information or questions fro you.
Please feel free to update this thread at any time.
I prepared a sample, trying the dates and the displayed dates are the same as on the server. Please review my sample and my screenshot.
Can you modify the attached sample to demonstrate the behavior you are observing?
In which time zone are you and in which time zone is your server?
Also does your data uses GridDataSourceAction attribute?