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, ... Date Time Parameter Pl...

Finance | Project Operations, Human Resources, ...

Answered

Date Time Parameter Plus Time Zone

(0) Share

Report

Report

Posted on by brianmaric

Scenario:

We have an application where the user preference is Pacific Standard Time.

I have a table that I am using in an SSRS Report and I am querying the table based on createddatetime.

The contract class uses a 'date' parameter.

I pass the date parameter to the DP class and convert it to a utcdatetime data type.

But I need to covert it to UTC date time by adding 7 hours since the date entered by the user will Pacific Standard Time.

Is there better way to do this?

Is there a function I can call to convert Pacific Standard time to UTC.

I'm concerned about day light savings time.

Thanks in advance

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

zhifeng on at

Like (0)

Report

Can you use expression in SSRS report?

=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.ToDisplayStringDate(Parameters!AX_RenderingCulture.Value, Date Field value, "d")

Or

=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, =Fields!TransDate.Value, "d", Parameters!AX_RenderingCulture.Value)

Read more from: https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/troubleshoot-issues-with-printing-and-emailing-reports?redirectedfrom=MSDN

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Brainmaric,

For data provider converstion you can check also DateTimeUtil class

docs.microsoft.com/.../convert-from-time-zone-before-persisting-in-x

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

You can use DateTimeUtil::removeTimeZoneOffset(). Also, you'll likely want to use DateTimeUtil::getUserPreferredTimeZone() instead of a hard-coded timezone.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 503 Most Valuable Professional

#2

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

#3

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans