Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : N8agyR9GLGWh+f3rWNcg3p
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Change TimeZone Settin...
Microsoft Dynamics CRM (Archived)

Change TimeZone Setting for Users

Like (0) ShareShare
ReportReport
Posted on 19 Feb 2010 16:26:26 by Utsav Acharya 570

Hi Everyone,

I wanted to know how can an administrator can change a TimeZone of any User from the CRM.

 If I want to view/change the TimeZone of a User from the database, then which tables i need to look into?

Thanks in Advance.

 

*This post is locked for comments

  • EdCan Profile Picture
    EdCan 346 on 21 Mar 2023 at 17:35:32
    RE: Change TimeZone Setting for Users

    You could also use the XRMToolBox User Settings tool to bulk change user settings.

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,508 on 21 Mar 2023 at 06:34:15
    RE: Change TimeZone Setting for Users

    Hello Utsav,

    Open the file menu above the ribbon bar,Go to Setting-> Click the Option

    88218.png


    Set Personal Options dialog opens (see below). In the General  tab, in the Set the time zone you are in section, open the Time Zone drop-down menu and select your local time zone, in our example,


    (GMT-8:00) Pacific Time (US & Canada)”, and click OK.

  • Suggested answer
    Testuser12 Profile Picture
    Testuser12 270 on 24 Jun 2013 at 07:13:47
    RE: Change TimeZone Setting for Users

    Hi,

    The timezone for a given user is actually read directly from the OS that the user is running so there is no way of manipulating this via the database.

    Regards

  • Community Member Profile Picture
    Community Member on 24 Jun 2013 at 06:51:49
    RE: Change TimeZone Setting for Users

    Hi Utsav,

    As others mentioned here there is no supported way of doing this, I also had similer requirement and you can see my steps in below blog post

    micodes.blogspot.sg/.../crm-2011-update-user-time-zone-from-sql.html

    Thanks

  • Community Member Profile Picture
    Community Member on 20 Jun 2013 at 19:45:34
    RE: Change TimeZone Setting for Users

    would like this feature as well (particular for service accounts)

  • Inogic Profile Picture
    Inogic 438 on 20 Feb 2010 at 01:17:36
    Re: Change TimeZone Setting for Users

    Hi,

    There is no supported way in CRM to go ahead and update the Time zone of all users in CRM. They will need to login and change their settings.

    If you want to go the database route, you may want to check the UserSettings table.. note you are going into the unsupported zone so a backup before you start changing in there would be advisable :)

    Sam

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,933 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,801 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans