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,382

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)

Suggested answer

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

Like (0)

Report

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,382 on at

Like (0)

Report
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 237,970 Most Valuable Professional on at

Like (0)

Report
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

André Arnaud de Cal... 456 Super User 2025 Season 2

#2

Martin Dráb 429 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans