UTC Date time to System Date time in X++

(0) Share

Report

Posted on by D365 beginner

634

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.

I have the same question (2)

All responses (3)

Answers (2)

Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report
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()));

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

D365 beginner 634 on at

Like (0)

Report

This works perfect. Thanks

Was this reply helpful? Yes No