Microsoft KB Archive/939809

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

Article ID: 939809

Article Last Modified on 11/22/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services 3.0

-



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

This issue occurs when one or more of the following conditions are true:
 * You install a Windows SharePoint Services 3.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
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 3.0 (KB941422) 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 3.0 is required 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 modified the Timezone.xml file is required. You must include this date when you use the –update before –date  parameter.
 * If you installed a software update that updated the Timezone.xml file after you installed Windows SharePoint Services 3.0, 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  parameter that is described in the &quot;Command syntax&quot; section.
 * If you installed a software update that updated the Timezone.xml file after you installed Windows SharePoint Services 3.0, you must determine the date on which the update was installed. To do this, follow these steps:
 * Click Start, click Control Panel, and then double-click Add or Remove Programs.
 * At the top of the Add or Remove Programs dialog box, click to select the Show updates check box.
 * Under Windows SharePoint Services, locate the update for Windows SharePoint Services (KB ).
 * 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  parameter that is described in the &quot;Command syntax&quot; section.

How to install the software update

 * 1) In Microsoft Windows Explorer, double-click the WSSv3-kb939809-fullfile-x86-glb.exe file or the WSSv3-kb939809-fullfile-x64-glb.exe file, and then follow the instructions.
 * 2) Change to the folder from which you extracted the files.
 * 3) Double-click the .exe file to install the update.
 * 4) Repeat steps 1 through 3 on each server in the farm that is running Windows SharePoint Services 3.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 \Common Files\Microsoft Shared\Web Server Extensions\12\BIN

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



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  –update < before –date , all >

stsadm.exe –o tzmove –name  –clear

Examples of how the commands are used are as follows:
 * stsadm –o tzmove –name  –update before -date  

This command updates future data that was modified before. In this command,  is the date that you specify.
 * stsadm –o tzmove –name  –update all

This command updates future data.
 * stsadm –o tzmove –name  –clear

This command clears the flag on a particular time zone.

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 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 , items that were created on   are not updated. To update items that were created or modified on , you must enter -update before -date   +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. &quot;Created on&quot; dates and &quot;Modified on&quot; 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  –update before –date  

Note In this command,  is the date on which you intalled 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  –update before -date  

Notes  In this command,  is the date on which the Timezone.xml file was modified.</li> 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.</li></ul> </li> 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  -update all

In this command, all future data is updated.</li> 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  -clear

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

Frequently asked questions
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 line.

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 line, the date is modified again.

<div class="references_section">