UTC Date time to System Date time in X++

(0) Share

Report

Posted on by D365 beginner

618

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 (0)

All responses (3)

Answers (2)

Verified answer

Martin Dráb 236,394 Most Valuable Professional on at

Like (0)

Report
RE: UTC Date time to System Date time in X++

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

RE: UTC Date time to System Date time in X++

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 618 on at

Like (0)

Report

RE: UTC Date time to System Date time in X++

This works perfect. Thanks

Was this reply helpful? Yes No