Hi, I'm recieving UTC dates from the server formatted as JSON, what I want to find out is how the grid handles UTC date. displaying the dates as local time received from the server and to the server when filering on date columns?
Please can u advice on how to resolve this issue.
Thanks in advanced.
Regards Christoff
Hi MolallaComm,
The "enableUTCDates" property is not inside the 12.1 Volume Release. However it will be in the next 12.1 Service Release (8th June).
The reason you're seeing it inside the documentation for 12.1 is a mixup in the documentation generation. As i mentioned the "enableUTCDates" is going to be in the next SR and documentation just got updated prematurely.
Thanks for pointing that out! Sorry for the confusion this may have caused.
Ivan Kosharov
Hi there, after upgrading to 12.1 and removed the formatting function my dates are now being displayed correctly. Looks like something did change when the JSON date strings are parsed from version 11.1 and 11.2?
Thanks again.
Actually, in looking at the 2012.1 documentation, it appears that there is an "enableUTCDates" property on the grid that might be the ticket on this problem, but unfortunately I don't think it currently is wired up to do anything. Can someone from Infragistics confirm or deny this???
I have to agree with Christoff here. I'm using 2012.1 latest greatest with oData and the DateTime columns in the database are local times, but when they get sent via JSON the WCF Data Service layer unfortunately converts them into UTC (if I recall, this is a feature of microsoft's json routines in general - if you use JSON.net instead it isn't an issue but unfortunately WCF Data Services are hard wired to use microsoft's own JSON routines).
it is easy enough to write a custom formatter, but it would be nice if we didn't have to as then things would just work out of the box. How about just adding a new format option called "dateTimeUTC" or something to signify that the underlying datasource is providing the time in UTC format even though we want to display it in local time format?
Hi Christoff,
I've attached a sample with the igHierarchicalGrid that demonstrates the regional settings that apply to dates and numbers formatting.Internationalization and regional settings have been supported since the 1st release of our jQuery product (2011.1) so you can use them without any problems.The "regionalization" JS files are currently located at:\Infragistics\NetAdvantage 2011.2\jQuery\js\i18n\igRegional
The only actual requirement is that if you wish to reference a regional JS file, you will need to do so after the ig.util.js file has been referenced. For example:
<script type="text/javascript" src="http://localhost/ig_ui11.2/js/ig.util.js"></script><script type="text/javascript" src="http://localhost/ig_ui11.2/js/i18n/igRegional/ig.ui.regional-bg.js">/script><script type="text/javascript" src="http://localhost/ig_ui11.2/js/ig.dataSource.js"></script><script type="text/javascript" src="http://localhost/ig_ui11.2/js/i18n/igDataSource/ig.dataSource-en.js"></script>
If we can help you out with anything else, please let us know.
PS: If you can't download the sample from my post, you can also find it here: https://skydrive.live.com/?cid=e4cf03e23fe33afe&resid=E4CF03E23FE33AFE!123&id=E4CF03E23FE33AFE%21123