web

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

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 236,320 Most Valuable Professional on at

Like (0)

Report

RE: Getting wrong date and time

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
RE: Getting wrong date and time

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 236,320 Most Valuable Professional on at

Like (0)

Report
RE: Getting wrong date and time

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

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

#1

CA Neeraj Kumar 2,122

#2

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

#3

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans