UTC Date time to System Date time in X++

(0) Share

Report

Posted on by D365 beginner

636

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 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

This works perfect. Thanks

Was this reply helpful? Yes No