EVALUATE DateTime in XML Format

einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
edited 2013-10-02 in NAV Three Tier
Hi guys,

did anyone came across an issue when trying to EVALUATE a DateTime in XML Format?
DateTimeText := '2013-10-02T16:10:23.456Z';
EVALUATE(NewDateTime,DateTimeText,9);
MESSAGE('%1',NewDateTime);
As stated in ISO 8601 http://en.wikipedia.org/wiki/ISO_8601 the Z indicates that the given datetime is UTC. When you remove the Z NAV should take it as local time. This works fine in CC. But when you do it in 2009 R2 RTC then it still takes it as UTC.

I also checked the CustomSettings.config file to see if it depends on the TimeZone value but that doesn't have any impact.

I think it's a bug. :bug:
"Money is likewise the greatest chance and the greatest scourge of mankind."
Sign In or Register to comment.