Finance | Project Operations, Human Resources, ...

How to get the system time zone from code

(0) Share

Report

Posted on by DAX Dev

Hello,

is there way to get the "+01:00" from defined timezone?

For example, the setup is:

(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna

But I need to have only +01:00.

Is there any standard method for it?

Thanks.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: How to get the system time zone from code

What would you use it for? Could you describe your business requirement?

Or do you mean the user's timezone? You can get it by DateTimeUtil::getUserPreferredTimeZone().

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

RE: How to get the system time zone from code

Hi,

As mentioned by Nikolas, not sure what is your requirement but you can check this document for any of the date related functionality: docs.microsoft.com/.../gg837448(v=ax.60)

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report

RE: How to get the system time zone from code

Client request this format in one of the generated xml files (Customization).

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: How to get the system time zone from code

As far as I understand, your question isn't related to getting the system time zone via code.

Could you share more details. Is it about the format of a date/time field? Or some timezone field?

How is the XML created? Via Data management? Or your custom code?

Please share the XML that the system produces now, as well as description how you would like it to appear. And any custom code that you have related to this process.

Was this reply helpful? Yes No
Deepak Agarwal 8,585 on at

Like (0)

Report

RE: How to get the system time zone from code

Hello,

There is no standard method for this. You need to build your logic something like, convert time in str and use substring method get last 6 characters.

Give a try and let me know if you need any further help there.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

RE: How to get the system time zone from code

Hi DAX Dev,

As Nikolaos said, please share your XML file.

And if you just want to add one hour to the time, you could use

transDateTime = DateTimeUtil::addHours(transDateTime, 1);

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: How to get the system time zone from code

Hi DAX_Dev ,

I agree with Deepak. You need to get timezone using dateTimeUtil class and then use your own logic by converting that value in a string format and using string function to get the desire output. Whatever you are using to generate your xml may be its your own class, external library or data entity you have to write your own logic.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,495 Most Valuable Professional on at

Like (0)

Report
RE: How to get the system time zone from code

You can use .NET string formatting functions with '%K' format specifier. Like this:

System.DateTime datetime = ...; str tzOffset = System.String::Format('{0:%K}', datetime);

It'll display the timezone used by the DateTime value - make sure that the value is in the timezone you want (apply the timezone if it isn't).

Was this reply helpful? Yes No