![](/file/18315/Y2K_Resource_Nov99.iso/webcon~1/usa/year2k/images/spacer.gif)
Microsoft Year 2000 Readiness Disclosure & Resource Center |
![](/file/18315/Y2K_Resource_Nov99.iso/webcon~1/usa/year2k/images/spacer.gif) |
![](/file/18315/Y2K_Resource_Nov99.iso/webcon~1/usa/year2k/images/spacer.gif) |
![](/file/18315/Y2K_Resource_Nov99.iso/webcon~1/usa/year2k/images/spacer.gif) | Works (Mac) 4.0 (English Australian) - Mac
Product Summary |
Product: Works (Mac) Version: 4.0 |
Category: Compliant Operating System: Mac |
Language: English Australian |
Release Date: 10 Jul 1994 |
Operational Range: |
01 Jan 1904 - 06 Feb 2040 |
Prerequisites: |
None |
Product Dependencies: |
Macintosh Operating System |
Clock Dependencies: |
System Clock |
Last Updated: |
03 May 1999 | |
Product Details |
Summary:
The way that Microsoft Works 4.0 for the Macintosh interprets dates that are entered with a 2-digit year value is dependent on the current date setting for the operating system and is summarized in the table below. This product was designed to store dates as serialized numbers, regardless of the visual cell format chosen by the user. Users do not have to go back into files/records and change dates to 4-year format.
How the product handles dates:
Storage:
Microsoft Works 4.0 for the Macintosh stores dates internally as serial numbers from 0 to 49710, where 0 is the serial number for January 1, 1904 and 49710 is the serial number for February 6, 2040. For example, if the date 1/1/1905 is entered, Microsoft Works stores it internally with a value of 366 since this is the number of days since (and including) the serial starting point of January 1, 1904. If the date 6/1/1998 is entered, Microsoft Works stores it internally with a value of 34485 and so on, since this is the number of days since the starting point of 1/1/1904. In addition, Microsoft Works stores 4-digit years in files even when entry uses only 2 digits.
Two-Digit Shortcut Handling:
If a date is entered with a 2-digit year (i.e. 6/1/98), Microsoft Works 4.0 for the Macintosh has four distinct behaviors, depending on four distinct system date ranges. The table below describes how Microsoft Works 4.0 for the Macintosh interprets a 2-digit year value depending on the current system date (which is set in the operating system):
Two-digit parsing rules for year input - Microsoft Works 4.0 (Macintosh) |
System Date |
2-digit year Input Ranges |
How Works interprets the year value when entered |
Example |
Date Entered |
Interpreted As |
1920û1990 |
00-03 |
invalid range for this system date |
1/1/02 |
invalid date |
04û99 |
19xx |
1/1/10 |
1/1/1910 |
1991-1999 |
00-10 |
20xx |
1/1/09 |
1/1/2009 |
11-99 |
19xx |
1/1/35 |
1/1/1935 |
2000-2010 |
00-40 |
20xx |
1/1/35 |
1/1/2035 |
41-90 |
invalid range for this system date |
1/1/55 |
invalid date |
91-99 |
19xx |
1/1/95 |
1/1/1995 |
2011-2019 |
00-40 |
20xx |
1/1/35 |
1/1/2035 |
41-99 |
invalid range for this system date |
1/1/55 |
invalid date |
Sorting:
Microsoft Works 4.0 sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Microsoft Works 4.0 sorts dates when some are prior to 2000 and some are after 2000.
Leap Years:
Microsoft Works 4.0 executes leap years and displays 2/29 in appropriate years, including the year 2000 and after.
Display:
Users can select several different visual formats for dates, without changing the underlying value of the actual date itself. The formula bar in the Spreadsheet will display a 4-digit year (YYYY) regardless of the cell format (YY or YYYY). The formula bar in the Database will display the year as 2 or 4 digits, mirroring the default system date format.
Additional Information:
The DATE() function (which can be used to build formulas in the spreadsheet and database) is not designed to take 2-digit year shortcuts, since it receives numeric parameters. For the Year argument of the DATE() function, numbers less than 1900 are calculated as an offset from 1900. Year arguments with a value of 1900 or greater are interpreted as the 4-digit year value they represent. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. If you were to enter a formula such as =DATE(115,1,1), the resulting date would be January 1, 2015. Similarly, if you were to enter a formula such as =DATE(2015, 1, 1) the resulting date would be January 1, 2015.
| |
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.
|