Time Zone Setting in Microsoft CRM


How does Microsoft Dynamics CRM treats time zone?  All date/time entries are recorded as Greenwich Mean Time (GMT) at the database level based on the Microsoft CRM Server’s time clock.  Upon the date/time data entry or display, Microsoft CRM will factor in the CRM User’s Time Zone setting and accordingly adjust it based on the GMT’s value.

You can access your Time Zone setting via Microsoft CRM Web Client >> Tools menu >> Options >> General tab:

Note: If the “Set the time zone you are in” does not appear – close both the Microsoft CRM Web Client and Microsoft CRM Outlook Client.  Then re-open only the Microsoft CRM Web Client.  Having both the Microsoft CRM Web Client and Microsoft CRM Outlook Client open – the  “Set the time zone you are in” will not display

If you are using the Microsoft CRM Outlook Client – the Time Zone setting will be automatically set for you based on your Windows Time Zone setting:

Here is a scenario to better describe this:

It is 10AM on April 22nd and CRM User One’s Time Zone setting is the Pacific Time (-8 GMT).  If CRM User One created a CRM Contact record – the created date is 4/22 6PM (GMT) on the Microsoft CRM database.  When CRM User One views this contact record in his Microsoft CRM Client, it will display 4/22 10AM because Microsoft CRM will display it based on CRM User One’s Time Zone setting.

Another CRM User (CRM User Two) has his Time Zone setting at Eastern Time (-5 GMT), if CRM User Two was viewing CRM User One’s contact record created above, the created date will be displayed as 4/22 1PM (vs. 4/22 10AM for CRM User One).

Here is an interesting question that comes up:

What happens if due to the Time Zone, it is the next day? 

The answer is that Microsoft CRM will display the date respective to the Microsoft CRM User’s Time Zone setting.   If CRM User One (Pacific Time zone) created another CRM contact record at 11PM on April 22nd, that record’s created date will be shown as 2AM April 23rd (vs April 22nd) if viewed by CRM User Two (Eastern Time zone).  Be sure to take this into account when designing your CRM processes.

Here is a blog with more insight into Microsoft CRM Time Zone: 
http://blogs.msdn.com/crm/archive/2007/05/22/date-time-values-in-microsoft-dynamics-crm.aspx

 
 

Contact me if you need help with your Microsoft CRM. Free Estimate.

FREE Microsoft CRM Online 30 Day Trial access with our Professional Assistance!

Frank Lee, Microsoft CRM MVP since 2006
Workopia

Advertisements

About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
This entry was posted in CRM On Premise, CRM Online, Microsoft CRM, Microsoft Dynamics CRM, MS CRM and tagged , , . Bookmark the permalink.

3 Responses to Time Zone Setting in Microsoft CRM

  1. Pingback: Dynamics CRM and the Trouble with Time Zones

  2. Pingback: Dynamics CRM and the Trouble with Time Zones - Richard Knudson’s Microsoft Dynamics CRM Trick Bag - CRM Technical Blogs - Microsoft Dynamics Community

  3. John says:

    It’s 6 years since this post but I just picked up a 2011 project so I thought I’d mention that CRM stores dates as UTC, not GMT.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s