Revision as of 08:48, 20 July 2020

Knowledge Base

An update is available that addresses an issue in which items that use the Date and Time fields are off by one hour in Microsoft Windows SharePoint Services 2.0

Article ID: 933738

Article Last Modified on 10/18/2007

APPLIES TO

Microsoft Windows SharePoint Services 2.0
Microsoft Office SharePoint Portal Server 2003

INTRODUCTION

This article describes the scheduled software update that addresses an issue in Microsoft Windows SharePoint Services 2.0. In this issue, items that use the Date and Time fields are off by one hour. This issue occurs if the following conditions are true:

You install any Windows SharePoint Services 2.0 software update that is dated January 9, 2007 or later.
You manually change the TIMEZONE.XML file to reflect the daylight saving time (DST) changes that are new for 2007 (DST 2007).

This update was first included in Windows SharePoint Services 2.0 Service Pack 3. For more information about the latest service pack for Windows SharePoint Services 2.0, click the following article number to view the article in the Microsoft Knowledge Base:

906795How to obtain the latest service pack for Windows SharePoint Services 2.0

MORE INFORMATION

Because Microsoft Windows SharePoint Services 2.0 and Microsoft SharePoint Portal Server 2003 are built on the Windows SharePoint Services 2.0 platform, they are affected by the scheduled DST 2007 changes that will occur on March 11, 2007.

Recently, a software update was released that included a TIMEZONE.XML file to address this issue. For more information about this software update, click the following article number to view the article in the Microsoft Knowledge Base:

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

For more information about how to manually update the TIMEZONE.XML file, click the following article number to view the article in the Microsoft Knowledge Base:

933853 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

However, after this update was released, additional testing determined that some existing items may be off by one hour. By default, these items include Events, Tasks, and Announcements as examples. However, customized lists that include a Date and Time field are also affected.

Note This issue includes future and past events.

To address this issue, a software update is available. The following file is available for download from the Microsoft Download Center:
Download the WSS 2003 - Hotfix 18403 - Office 11 package now. For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Installation requirements

Windows SharePoint Services 2.0 Service Pack 2 (SP2) is required to install this software update.

To download Windows SharePoint Services 2.0 SP2, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=9C552114-DC9A-43EE-9281-B080B7C280B4&displaylang=en
If you manually updated the TIMEZONE.XML file instead of installing update 924881 for the Windows SharePoint Services 2.0 software, you must document the modified date of the file before you install this software update.

This software update is cumulative, and it includes the TIMEZONE.XML file from update 924881. This condition causes the TIMEZONE.XML file to have a new modified date after you install this software update.

The actual modified date on which you changed the TIMEZONE.XML file is required for this scenario. You must include this date when you use the –update before –date YYYYMMDD parameter.
If you installed other software updates after Windows SharePoint Services 2.0 SP 2, you must follow these steps to determine whether an updated TIMEZONE.XML file already exists:
1. Click Start, click Control Panel, and then double-click Add or Remove Programs.
2. At the top of the Add or Remove Programs dialog box, click to select the Show updates check box.
3. Under Windows SharePoint Services 2.0, locate the update for Windows SharePoint Services 2.0 (KB######).
  
  In this example, ###### is a placeholder for any of the following numbers:
  - 927878
  - 929189
  - 930103
  - 930476
  - 930773
  - 932057
  If you have more than one of these updates, you will need the date of that earliest update in order to suitably run the stsadm.exe command to update the Date and Time fields to match the new daylight saving time.
4. In the Add or Remove Programs dialog box, examine the Installed on column. This column contains the date on which the TIMEZONE.XML file was installed. You must include this date when you use the –update before –date YYYYMMDD parameter.
  
  If only update 924881 was installed, determine the date on which it was installed. Include this date when you use the –update before –date YYYYYMMDD parameter.

How to install the software update

In Microsoft Windows Explorer, double-click the WSS2003-KB934000-GLB.exe file, and then follow the instructions.
Change to the folder from which you extracted the files.
Run the Sts.msp file.
Repeat step 1 on each server in the farm.

How to run the stsadm.exe command

Log on to the computer that is running Windows SharePoint Services 2.0 by using a domain account that is an Administrator on the Web server and on servers that are running Microsoft SQL Server.

Alternatively, use a domain account that is an Administrator on the Web server and that has Database Creator and Security Administrator roles. This account should have database access to all Windows SharePoint Services 2.0 databases in SQL Server.
Click Start, point to All Programs, point to Accessories, and then click Command Prompt.
At the command prompt, type the following commands. Press ENTER after each command:

cd /d %programfiles%\Common Files\Microsoft Shared\Web Server Extensions\60\BIN

stsadm.exe –o tzmove –name DST2007 –update before –date YYYYMMDD

Note The update date is required. This date determines the date range that the tool should target.

When you run this command, items for which the following conditions are true will be adjusted:

The item's modified date falls before the date that is specified on the command line.
The item's date values and time values fall within the extended DST 2007 zone or later.

This command does not adjust any items for which the following conditions are true:

The item's modified date falls after the date that is specified on the command line.
The item's date values and time values fall within the extended DST zone in 2006 or earlier.

Items whose date values and time values fall within the DST zone in 2006 or earlier will be updated if you upgrade to Microsoft Windows SharePoint Services 3.0 and if you do not modify these items after you run the stsadm.exe command.

Definitions

Future Data: These are items that contain date values and time values that occur in the extended DST 2007 zone and later.
Past Data: These are items that contain date values and time values that occur in extended DST in 2006 zone and earlier.

Note DST starts in the second week of March. In 2007, DST starts on March 11. This start date is three weeks earlier than the start date that was used in earlier years. DST ends in the first week of November. In 2007, DST ends on November 4. This end date is one week later than the end date that was used in earlier years.

Command syntax

stsadm.exe –o tzmove –name DST2007 –update < before –date YYYYMMDD, all >

Examples of syntax are as follows:

stsadm –o tzmove –name DST2007 –update before -date YYYYMMDD

This command updates Future Data that was modified before YYYYMMDD. In this command, YYYYMMDD is the date that you specify.

stsadm –o tzmove –name DST2007 –update all

This command updates Future Data.

Important

Before you install this update, make sure that you that you back up the data. You cannot roll back changes that were made after you run this software update.
Before you run this software update, you must determine whether the TIMEZONE.XML file was modified. This file may have been modified when you installed an additional software update. Alternatively, the file may have been modified manually.
When you enter –update before –date YYYYMMDD, items that were created on YYYYMMDD are not updated.

NoteYYYYMMDD is today's date.

In order to update items that were created or modified on YYYYMMDD , you must enter -update before -date YYYYMMDD +1 for the changes to take effect.

When you run this software update, only Future Data items are updated. Past Data items are not updated. These items remain one hour off. In some cases, these items may be one day off. For example, if an item occurs on or before March 14, 2007 at 11:00 A.M., the item may appear as March 16, 2007 at midnight (00:00) after you run the software update.
If you updated the TIMEZONE.XML file during the DST period, only date values and time values of Future Data are updated. Created on dates and Modified on dates of Future Data are not updated.
This update does not update past versions of items.
If a document (not a regular list item) has a date-time field that has a value that falls into the window between the new and old DST, the correctly updated value is overwritten with the old value when the item is checked in. This occurs if the document is checked out when the tool is run.
If a you restore a database that was backed up before the tool was run, you must run the tool on the restored database

Sample scenarios

If you previously installed update 924881, you must use the following command to update the Future Data items:

stsadm –o tzmove –name DST2007 –update before –date YYYYMMDD

In this command, YYYYMMDD is the date on which update 924881 was installed.
If you did not install update 924881 and you modified the TIMEZONE.XML file, you must use the following command to update the Future Data items:

stsadm –o tzmove –name DST2007 –update before -date YYYYMMDD

In this command, YYYYMMDD is the date on which the TIMEZONE.XML file was changed.

Note If you manually updated the TIMEZONE.XML file instead of installing update 924881, you must document the modified date on the file before you install this software update.

This software update is cumulative, and it includes the TIMEZONE.XML file from update 924881. This condition causes the TIMEZONE.XML file to have a new modified date after you install this software update. The actual modified date of the TIMEZONE.XML file is required for this scenario.
If you did not install update 924881, and if you did not modify the TIMEZONE.XML file, you must use the following command to update the Future Data items:

stsadm -o tzmove -name dst2007 -update all

In this command all Future Data is updated
Consider the following scenario. You did not install update 924881 or modify the TIMEZONE.XML file. However, you verify that an earlier update has modified the TIMEZONE.XML file as described in the "Installation requirements" section.

You must use the following command to update Future Data items:

stsadm -o tzmove -name DST2007 -update before -date YYYYMMDD

In this command, YYYYMMDD is the date of the earliest update that was installed.

What happens when you upgrade to Windows SharePoint Services 3.0

Past Data that is never edited is corrected after the upgrade.
Past Data that is created or modified after you run TZMOVE is incorrect after the upgrade. (In this example, tzmove is the command for this update.)
Past Data that is created or modified after you install update 924881 is not corrected after the upgrade.

Frequently asked questions

What are the requirements to install this software update for unsupported versions of Windows SharePoint Services 2.0 or of Windows SharePoint Services 2.0 Service Pack 1 (SP1)?

You must install Windows SharePoint Services 2.0 SP2 before you install this software update.
What happens if I manually updated the TIMEZONE.XML file?

This software update provides an option for you to include the modified date as a command line argument. This procedure prevents the update of any items that were modified after the TIMEZONE.XML file was modified.
Will the stsadm.exe tool double-modify dates that have previously been changed manually?

Not if the dates were modified after you modified the TIMEZONE.XML file and if you specified the date on which the TIMEZONE.XML file was modified in the stsadm -o tzmove command line.

However, if the date occurs in 2007 or later but was changed manually before the date that was specified in the stsadm -o tzmove command line, the dates are modified again.
I've applied update 924881. Do I have to apply update 933738?

Yes, we recommend that you install 933738 or later because 933738 was created when the tzmove operation was first added to stsadm. We recommended that you run the tzmove operation.
I have not applied 924881. Do I have to before I apply 933738?

No, you do not have to apply update 924881. This is because all Windows SharePoint Services 2.0 updates are cumulative. Any update that was in a previous update is included in update 933738. This includes the TIMEZONE.XOM file that was in update 924881.
What happens if I do not install the TIMEZONE.XML file update or the stsadm.exe tool update?

If you do not upgrade the Windows SharePoint Services 2.0 environment to Windows SharePoint Services 2.0 Service Pack 2, or if you do not apply update 924881 or a later update, the TIMEZONE.XML file is not DST 2007-compliant. Additionally, items that occur within the following dates may 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.) For more information about how to manually update the TIMEZONE.XML file, click the following article number to view the article in the Microsoft Knowledge Base:

933853 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

REFERENCES

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