Microsoft KB Archive/934610

= Time dependent items and date dependent items are not automatically adjusted in Microsoft Dynamics CRM 3.0 if you change the time zone setting for a user =

Article ID: 934610

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-



SYMPTOMS
If you change the time zone setting for a user in Microsoft Dynamics CRM 3.0, time dependent items and date dependent items, such as appointments, are not automatically adjusted for the change as expected.



WORKAROUND
To work around this issue, manually change the time settings and the date settings for each item as required. For example, change the start time and the end time for each appointment that was scheduled before the time zone setting was changed.



MORE INFORMATION
By default, when a Microsoft Dynamics CRM user is created, the user is created in the Pacific Time (US and Canada) zone. If the user creates records in Microsoft Dynamics CRM that are dependent on the time and on the date, such as appointments, the records are stored in the Microsoft CRM SQL database in the user's time zone. In this case, the appointment is stored in the Pacific Time zone. If the user changes the time zone setting, the records in the Microsoft CRM SQL database are not changed to reflect the new time zone setting. Therefore, the user has to go back through each record to correct the time to reflect the new time zone that the user is now in.

For example, a Microsoft Dynamics CRM user in the Central Time (US and Canada) zone creates an appointment to start at 8:00. Then, the user discovers that the time zone setting in Microsoft Dynamics CRM is incorrectly set to the Pacific Time (US and Canada) zone. Therefore, the appointment is stored in the Microsoft CRM SQL database as 8:00 Pacific Time (US and Canada). Then, the user changes the Microsoft Dynamics CRM time zone setting from the Pacific Time (US and Canada) zone to the Central Time (US and Canada) zone. Microsoft Dynamics CRM now reads the appointment time as 10:00. The appointment time is now incorrect. To correct the scheduled appointment, the user must manually adjust the appointment after the time zone setting is changed.

Additional query words: crm3 crm30 crm3.0 rebase re-base

Keywords: kbdatetime kbprb kbmbsmigrate kbtshoot kbexpertisebeginner KB934610

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.