Microsoft Year 2000 Readiness Disclosure & Resource Center

Product Summary

Product: Works Version: 4.0 Category: Compliant* Operating System: 32-Bit Win Language: English Release Date: 24 Aug 1995 Operational Range: 01 Jan 1900 - 03 Jun 2079 Prerequisites: Microsoft Works Year 2000 Update Product Dependencies: Works 4.0: Windows 95 or Windows NT 3.51 Clock Dependencies: System clock Last Updated: 17 Nov 1998

Product Details

What are the prerequisites for compliance? The user needs to install the Year 2000 update for Microsoft Works. The update is available from Microsoft Technical Support's web site at http://support.microsoft.com/support/kb/articles/q191/9/99.asp or directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 û unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 û unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing

Return to Search Screen

If after reviewing this information you have additional questions related to this product, click here.

ANY MICROSOFT YEAR 2000 STATEMENTS MADE TO YOU IN THE COURSE OF PROVIDING YEAR 2000 RELATED UPDATES, YEAR 2000 DIAGNOSTIC TOOLS, OR REMEDIATION SERVICES (IF ANY) ARE SUBJECT TO THE YEAR 2000 INFORMATION AND READINESS DISCLOSURE ACT (112 STAT. 2386). IN CASE OF A DISPUTE, THIS ACT MAY REDUCE YOUR LEGAL RIGHTS REGARDING THE USE OF ANY SUCH STATEMENTS, UNLESS OTHERWISE SPECIFIED BY YOUR CONTRACT OR TARIFF.

This site is being designated as a Year 2000 Readiness Disclosure and the information contained herein is provided pursuant to the terms hereof and the Year 2000 Information and Readiness Disclosure Act.