Knowledge Base

Description of the update that addresses the issue in Windows SharePoint Services 2.0 in which items that use the Date and Time fields are off by one hour

Article ID: 939770

Article Last Modified on 9/28/2007

APPLIES TO

Microsoft Windows SharePoint Services 2.0

INTRODUCTION

This article describes the software update (TZMOVE) that addresses the issue in Microsoft Windows SharePoint Services 2.0 in which items that use the Date and Time fields are off by one hour.

This issue occurs if one or more of the following conditions are true:

You install a Windows SharePoint Services 2.0 software update that modifies the daylight saving time (DST) period of a time zone definition in the Timezone.xml file.
You manually update the DST period of a time zone definition in the Timezone.xml file.

MORE INFORMATION

Update information

A software update is available to address this issue.
The following file is available for download from the Microsoft Download Center:
Download the Update for Windows SharePoint Services 2.0 (KB941412) 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

You must have Windows SharePoint Services 2.0 Service Pack 2 (SP2) installed to install this software update.
If you manually updated the Timezone.xml file instead of installing an update for the Windows SharePoint Services software, you must document the modified date of the file before you install this software update.
The actual date on which you changed the Timezone.xml file is required. You must include this date when you use the –update before –date YYYYMMDD parameter.
If you installed a software update that updated the Timezone.xml file after you installed Windows SharePoint Services, you must determine the name of the DST change.

Note To do this, refer to the appropriate article in the Microsoft Knowledge Base for the software update.

You must include this name when you use the –name name parameter that is described in the "Command syntax" section.

If you installed a software update that updated the Timezone.xml file after you installed Windows SharePoint Services, you must determine the date on which the update was installed. To do this, follow these steps:
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, locate the update for Windows SharePoint Services (KB######).
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 that is described in the "Command syntax" section.

How to install the software update

In Microsoft Windows Explorer, double-click the WSS2003-KB939770-fullfile-enu.exe.exe file, and then follow the instructions.
Change to the folder from which you extracted the file.
Double-click the .exe file to install the update.
Repeat steps 1 through 3 on each server in the farm that is running Windows SharePoint Services 2.0.

How to run the Stsadm.exe command

Log on to the computer that is running Windows SharePoint Services by using a domain account that has administrative permissions on the Web server and on the computers that are running Microsoft SQL Server.

Or, you can use a domain account that has administrative permissions on the Web server and that has Database Creator and Security Administrator roles. This account should have database access to all Windows SharePoint Services databases in SQL Server.
Click Start, click Run, type cmd in the Open box, and then click OK.
At the command prompt, type the following commands in the following order. Press ENTER after each command:

cd /d %programfiles%\Common Files\Microsoft Shared\Web Server Extensions\60\BIN
stsadm.exe –o tzmove –name name –update before –date YYYYMMDD

The date of the last update is required. This date determines the date range that the tool should target. This command adjusts items for which the following conditions are true:

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 new DST period in the year that the item first comes into effect and beyond.

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 new DST period in the years before the DST period first comes into effect.

Definitions

Future data: This data consists of items that contain date values and time values that occur in the new DST period in the year that the DST period first comes into effect and beyond.
Past data: This data consists of items that contain date values and time values that occur in the new DST period in the years before the DST period first comes into effect.

Command syntax

The syntax for the commands is as follows:

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

Examples of how the commands are used are as follows:

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

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

stsadm –o tzmove –name name –update all

This command updates future data.

stsadm –o tzmove –name name –clear

This command clears the flag on a particular time zone.

Important

Before you install this update, make sure that you back up the data. You cannot roll back changes that were made after you run this software update.
Before you run this update, you must determine whether the Timezone.xml file was modified. This file may have been modified when you installed an additional software update. Or, the file may have been modified manually.
When you enter –update before –date YYYYMMDD, items that were created on YYYYMMDD are not updated. 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.
If you updated the Timezone.xml file during the new 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.
A document that is not a regular list item may have a Date field or a Time field that has a value that falls into the window between the new DST period and the old DST period.

In this case, if the document is checked out when you run the tool, the correctly updated value is overwritten with the old value when the item is checked in.

If you restore a database that was backed up before you ran the tool, you must run the tool on the restored database.

Sample scenarios

If you previously installed an update that modified the DST period of a time zone definition, you must run the following command to update the future data items:

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

Note In this command, YYYYMMDD is the date on which you installed the update that modified the time zone definition.
If you did not install an update, and if you modified the Timezone.xml file, you must run the following command to update the future data items:

stsadm –o tzmove –name <name> –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 an update, you must document the modified date of the file before you install this software update.
If you did not install an update that modified the DST period of a time zone definition, you must run the following command to update the future data items:

stsadm -o tzmove -name name -update all

In this command, all future data is updated.
If the DST period for a time zone definition is modified again after you run the command, the previous data is not restored when you rerun the command. In this case, you must run the following command before you rerun the command:

Stsadm –o tzmove –name name -clear

This procedure clears the internal flags that are set by the command, and it enables data to be modified again.

Frequently asked questions (FAQs)

What happens after you upgrade to Microsoft Windows SharePoint Services 3.0?

Past data that is never modified is corrected.
Past data that is created or modified after you run the TZMOVE update is incorrect. 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.

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

You must install Windows SharePoint Services 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.

Does the Stsadm.exe tool double-modify dates that were previously modified 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.

However, if the date is future data, and if the date was modified manually before the date that was specified in the stsadm -o tzmove command, the date is modified again.

REFERENCES

For more information about how to manually update the DST period for a time zone definition in Windows SharePoint Services, click the following article number to view the article in the Microsoft Knowledge Base:

888253 How to configure time zone information in Windows SharePoint Services by modifying the Timezone.xml file

For more information about how to manually update the Timezone.xml file to be compliant with the DST 2007 period, 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

Additional query words: WSS WSSv3 MOSS region time

Keywords: kbtshoot kbexpertiseinter kbinfo KB939770

Microsoft KB Archive/939770

Contents