| Microsoft Year 2000 Readiness Disclosure & Resource Center |
|
|
| Works 4.0 (Danish) - 32-Bit Win
| Product Summary |
Product: Works
Version: 4.0 |
Category: Compliant*
Operating System: 32-Bit Win |
| Language: Danish |
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: |
18 Mar 1999 | |
| Product Details |
|
What are the prerequisites?
The user needs to install the Year 2000 update for Microsoft Works. The update is available 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
| Legend of Symbols: |
| * |
The product is compliant with recommended customer action. This indicates a prerequisite action is recommended which may include loading a software update or reading a document. |
| # |
The product is compliant with an acceptable deviations from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability, or reliability of the product. |
| + |
The product is compliant with pending Year 2000 software updates. Future maintenance actions will be recommended shortly. See Product Guide for further details. |
| Note: Compliance ratings given for each product assume that all recommended actions have been taken. |
If after reviewing this information you have additional questions related to this product, click here.
YEAR 2000 READINESS DISCLOSURE
ALL COMMUNICATIONS OR CONVEYANCES OF INFORMATION TO YOU CONCERNING MICROSOFT AND THE YEAR 2000, INCLUDING BUT NOT LIMITED TO THIS DOCUMENT OR ANY OTHER PAST, PRESENT OR FUTURE INFORMATION REGARDING YEAR 2000 TESTING, ASSESSMENTS, READINESS, TIME TABLES, OBJECTIVES, OR OTHER (COLLECTIVELY THE "MICROSOFT YEAR 2000 STATEMENT"), ARE PROVIDED AS A "YEAR 2000 READINESS DISCLOSURE" (AS DEFINED BY THE YEAR 2000 INFORMATION AND READINESS DISCLOSURE ACT) AND CAN BE FOUND AT MICROSOFT'S YEAR 2000 WEBSITE LOCATED AT http://www.microsoft.com/year2000/ (the "Y2K WEBSITE"). EACH MICROSOFT YEAR 2000 STATEMENT IS PROVIDED PURSUANT TO THE TERMS HEREOF, THE TERMS OF THE Y2K WEBSITE, AND THE YEAR 2000 INFORMATION AND READINESS DISCLOSURE ACT FOR THE SOLE PURPOSE OF ASSISTING THE PLANNING FOR THE TRANSITION TO THE YEAR 2000. EACH MICROSOFT YEAR 2000 STATEMENT CONTAINS INFORMATION CURRENTLY AVAILABLE AND IS UPDATED REGULARLY AND SUBJECT TO CHANGE. MICROSOFT THEREFORE RECOMMENDS THAT YOU CHECK THE Y2K WEBSITE REGULARLY FOR ANY CHANGES TO ANY MICROSOFT YEAR 2000 STATEMENT. EACH MICROSOFT YEAR 2000 STATEMENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. CONSEQUENTLY, MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. MOREOVER, MICROSOFT DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARDING THE USE OR THE RESULTS OF THE USE OF ANY MICROSOFT YEAR 2000 STATEMENT IN TERMS OF ITS CORRECTNESS, ACCURACY, RELIABILITY, OR OTHERWISE. NO ORAL OR WRITTEN INFORMATION OR ADVICE GIVEN BY MICROSOFT OR ITS AUTHORIZED REPRESENTATIVES SHALL CREATE A WARRANTY OR IN ANY WAY DECREASE THE SCOPE OF THIS WARRANTY DISCLAIMER. IN NO EVENT SHALL MICROSOFT OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER REGARDING ANY MICROSOFT YEAR 2000 STATEMENT INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS, PUNITIVE OR SPECIAL DAMAGES, EVEN IF MICROSOFT OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, SO THE FOREGOING LIMITATION MAY NOT APPLY TO YOU. THE INFORMATION CONTAINED IN EACH MICROSOFT YEAR 2000 STATEMENT IS FOUND AT THE Y2K WEBSITE AND IS INTENDED TO BE READ IN CONJUNCTION WITH OTHER INFORMATION LOCATED AT THE Y2K WEBSITE, INCLUDING BUT NOT LIMITED TO MICROSOFT'S YEAR 2000 COMPLIANCE STATEMENT, THE DESCRIPTION OF THE CATEGORIES OF COMPLIANCE INTO WHICH MICROSOFT HAS CLASSIFIED ITS PRODUCTS IN ITS YEAR 2000 PRODUCT GUIDE, AND THE MICROSOFT YEAR 2000 TEST CRITERIA.
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.
|
