web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

field of type Whole number with format TimeZone

(0) ShareShare
ReportReport
Posted on by

Does anyone know how to get the value and the code that its related to the Time Zone value?  Example: 235 (GMT-12:00) International Date Line Week

*This post is locked for comments

I have the same question (0)
  • Verified answer
    TomSmelser Profile Picture
    1,570 on at

    This may help.

    stackoverflow.com/.../timezonecode-to-timezoneinfo

  • Suggested answer
    Aric Levin - MVP Profile Picture
    30,190 Moderator on at

    Take a look at the SDK for this purpose.

    msdn.microsoft.com/.../hh547406.aspx

    Also, since you are on-Premise, you can login to your SQL Server and run the following SQL statement against your CRM database:

    SELECT [TimeZoneCode] ,[TimeZoneDefinitionId] ,[UserInterfaceName] ,[StandardName] FROM [TimeZoneDefinitionBase]

    Hope this helps.

  • Community Member Profile Picture
    on at

    Thanks !!! It helped a lot

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Shidin Haridas Profile Picture

Shidin Haridas 2

#2
Abdullah13 Profile Picture

Abdullah13 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans