web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Getting wrong date and...

Finance | Project Operations, Human Resources, ...

Answered

Getting wrong date and time

(0) Share

Report

Report

Posted on by faiz7049

2,430

Hello Experts,

I have a display method under table CustInvoiceJour.

In method I used code like below:

utcDateTime Timestamp;
str Timestamp1;
Timestamp=this.createdDateTime;
Timestamp1=datetime2str(Timestamp);

and finally added Timestamp1 to QR code.When I check entry in under Inquiry form like below Date and Time is correct.

8171.T1.jpg

But in QR code information Date is correct but Time is not correct.

Thanks,

Faiz

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Suggested answer

Martin Dráb 239,142 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You forgot to apply user's timezone.

Datetime values are stored in UTC in database. They're automatically convert to user's timezone in forms, but it's your responsibility in your code.

Use DateTimeUtil::applyTimeZoneOffset().

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!
Hi Martin,

Sorry I did not know before. How to apply like

utcDateTime Timestamp, Timestamp2; str Timestamp1; Timestamp=this.createdDateTime; Timestamp2= DateTimeUtil::applyTimeZoneOffset(Timestamp,UTC 03:00); Timestamp1=datetime2str(Timestamp2);

Please guide me if you do not mind.

Thanks,

Faiz

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,142 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I don't think you really want to hard-code the timezone in code. Most likely, you want the timezone configured for the current user:

DateTimeUtil::applyTimeZoneOffset(timestamp, DateTimeUtil::getUserPreferredTimeZone()));

Alternatively you might want the timezone of the current company.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 649

#2

André Arnaud de Cal... 447 Super User 2026 Season 1

#3

Syed Haris Shah 242 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans