Hi All,
I am trying print or generate csv file which contains table created date time. At the table i can see created date time 2014-03-15 07:35:42.
But when i try to print or generate csv file i am getting the value as 2014-03-15T03:04:22Z0.
Can any one please tell me how to print
2014-03-15 07:35:42 ?
Awaiting your reply.
What AX saves to fields with utcDateTime are UTC values. AX GUI, including Table Browser, converts UTC values to the time zone of the user looking at the data (time zone can be set up in user’s Options). There is no such automatic conversion in code - it’s your responsibility to decide which time zone should be used and do the conversion (with the help of DateTimeUtil::applyTimeZoneOffset()).