UTC Date time to System Date time in X++

(0) Share

Report

Posted on by D365 beginner

604

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.

All responses (3)

Answers (2)

Suggested answer

D365 beginner 604 on at

Like (0)

Report

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

This works perfect. Thanks
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/
Verified answer

Martin Dráb 234,665 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()));

Community site session details

UTC Date time to System Date time in X++

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

UTC Date time to System Date time in X++

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates