Announcements
No record found.
Hi Experts,
I need to display start date time and end date time from a table in my report which is of type UTCDateTime now. how can I convert it to user timezone datetime.
StartDate = MyTable.StartDate
EndDate = MyTable.EndDate
Is there any code to convert it directly.
Thanks in advance.
The title says that you want to do it in X , but then you talk about a report. Can you clarify your needs, please?
If you need it in X , use DateTimeUtil::applyTimeZoneOffset():
DateTimeUtil::applyTimeZoneOffset(myTable.StartDate, DateTimeUtil::getUserPreferredTimeZone()));
Hi AXBeginner,
Have you tried this: docs.microsoft.com/.../how-to-convert-between-utcdatetime-and-system-datetime
https://stoneridgesoftware.com/working-with-utcdatetime-functionality-in-dynamics-ax-2012/
This works perfect. Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 429 Most Valuable Professional
CU10121822-0 366
André Arnaud de Cal... 360 Super User 2026 Season 2
