Microsoft KB Archive/933853

From BetaArchive Wiki
Knowledge Base


How to manually update the TIMEZONE.XML file to be DST 2007-compliant if you cannot install update 924881 or a later update for Windows SharePoint Services 2.0 software

Article ID: 933853

Article Last Modified on 8/15/2007



APPLIES TO

  • Microsoft Windows SharePoint Services 2.0
  • Microsoft Office SharePoint Portal Server 2003



INTRODUCTION

This article describes how to manually update the TIMEZONE.XML file in Microsoft Windows SharePoint Services 2.0 when you cannot install Microsoft Windows SharePoint Services Service Pack 2 (SP2) or when you cannot install update 924881 or a later update for Windows SharePoint Services software.

MORE INFORMATION

If you cannot update the Windows SharePoint Services 2.0 environment to Windows SharePoint Services 2.0 SP 2, or if you cannot apply update 924881 or a later update for Windows SharePoint Services software, the TIMEZONE.XML file will not be compliant with the 2007 daylight saving time (DST) changes.

Note The changes in DST for 2007 are known as "DST 2007."

In this case, events that occur during the following dates and times will be off by one hour:

  • March 11, 2007 at 2:00 A.M. through April 1, 2007 at 2:00 A.M. (from the start of the new DST through the start of the old DST)
  • October 28, 2007 at 2:00 A.M. through November 4, 2007 at 2:00 A.M. (from the end of the old DST through the end of the new DST)

Additionally, some items may be off by one day. For example, if the original date was March 15, 2007 at 11:00 P.M., the date may change to March 16, 2007 at midnight (12:00 A.M.)

To work around this problem, you can manually change the TIMEZONE.XML file to be DST 2007-compliant.

Important Follow these steps only if you cannot apply update 924881 for Windows SharePoint Services software or a later update. We recommend that you apply update 924881 or a later update instead of using these steps to manually update the TIMEZONE.XML file.

However, we do recognize that there may be special circumstances in which you cannot do this. If you cannot update the Windows SharePoint Services 2.0 environment, follow these steps:

  1. Make sure that you create a backup copy of the TIMEZONE.XML file.

    The TIMEZONE.XML file is located in the following folder on the computer that is running Windows SharePoint Services 2.0:

    %programfiles%\Common Files\Microsoft Shared\web server extensions\60\CONFIG\

  2. Right-click TIMEZONE.XML, point to Open With, and then click Notepad.

    The contents of the TIMEZONE.XML file should resemble the following example:

     <TimeZone ID="9" Name="(GMT-04:00) Atlantic Time (Canada)" Hidden="FALSE">
            <Bias>240</Bias>
            <StandardTime>
                <Bias>0</Bias>
                <Date>
                    <Month>10</Month>
                    <Day>5</Day>
                    <Hour>2</Hour>
                </Date>
            </StandardTime>
            <DaylightTime>
                <Bias>-60</Bias>
                <Date>
                    <Month>4</Month>
                    <Day>1</Day>
                    <Hour>2</Hour>
                </Date>
            </DaylightTime>
        </TimeZone>

    Note The Day field actually refers to "Week.” Therefore, "Month 3, Day 2, Hour 2" refers to March 11, 2007 at 2:00 A.M.

    In other words, it refers to the second Sunday of March at 2 A.M. "Sunday" is implied because the DayOfWeek element is not present.

  3. In the TIMEZONE.XML file, change the Month and Day fields from <Month>10</Month> and <Day>5</Day> to <Month>11</Month> and <Day>1</Day>.

    Additionally, change <Month>4</Month> and <Day>1</Day> to <Month>3</Month> and <Day>2</Day>.

    Do this for the following TimeZone IDs:

    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 28

    For example, change the TIMEZONE.XML file content for "TimeZone ID 9" to the following content:

    <TimeZone ID="9" Name="(GMT-04:00) Atlantic Time (Canada)" Hidden="FALSE">
            <Bias>240</Bias>
            <StandardTime>
                <Bias>0</Bias>
                <Date>
                    <Month>11</Month>
                    <Day>1</Day>
                    <Hour>2</Hour>
                </Date>
            </StandardTime>
            <DaylightTime>
                <Bias>-60</Bias>
                <Date>
                    <Month>3</Month>
                    <Day>2</Day>
                    <Hour>2</Hour>
                </Date>
            </DaylightTime>
        </TimeZone>
  4. Repeat step 3 for the remaining TimeZone ID values.
  5. After you finish changing the TIMEZONE.XML file, you must restart Microsoft Internet Information Services (IIS). To do this, follow these steps:
    1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
    2. In the IIS Manager Microsoft Management Console (MMC) snap-in, right-click the server that is running IIS, click All Tasks, and then click Restart IIS.

Important If you decide to use the stsadm.exe –o tzmove command after you manually modify the TIMEZONE.XML file, you must make sure that you carefully follow the manual modification instructions that are described in the following article in the Microsoft Knowledge Base:

933738 Items that use Date and Time field are off by one hour after you install the Microsoft Windows SharePoint Services software update dated January 9, 2007


Note Future Windows SharePoint Services software updates will include the TIMEZONE.XML update that was introduced in update 924881 for Windows SharePoint Services software. If you apply a later update at any time, the manually modified TIMEZONE.XML is overwritten.

REFERENCES

933360 August 2007 cumulative time zone update for Microsoft Windows operating systems


924881 Description of the update for Windows SharePoint Services: January 9, 2007


933738 Items that use Date and Time field are off by one hour after you install the Microsoft Windows SharePoint Services software update dated January 9, 2007


Keywords: kbhowto kbinfo kbexpertiseinter KB933853