Microsoft Year 2000 Readiness Disclosure & Resource Center

Product Summary

Product: Money Version: 2000 (8.x) Category: Compliant Operating System: 32-Bit Win Language: Japanese Release Date: 04 Aug 1999 Operational Range: - Prerequisites: None Product Dependencies: Windows 95 or later; Windows NT 4.0 Service Pack 4 or later Clock Dependencies: Operating system clock is not advanced beyond 2038 Last Updated: 28 Sep 1999

Product Details

Description of how the product accepts dates: Four Digit Dates. Money 2000 uses the OLE Automation "DATE" data type. This is represented as a double (8-byte floating point) value. The whole-number portion represents the number of days since Dec 30th, 1899 A.D. The fractional portion (which Money does not use very often) represents the fraction of a day to indicate a time (e.g., 0.25=6:00am, 0.5=noon, etc.). Dates that have no time representation are stored with no fractional part. For example, January 1st, 1900 would be represented as the number 2.0.   Two Digit Dates. Users can enter dates in Money as a 2-digit representation (e.g., 99, 00, 01) or a 4-digit representation (e.g., 1999, 2000, 2001). Example: in the check register, the user can enter the date 1/2/00. This date is recognized as 1/2/2000. The logic that Money uses for converting 2-digit years into the actual year varies depending on what Date data entry field is in question. Money generally uses a heuristic that compares the 2-digit year that has been entered to the current year. If the Year+1900 is more than 33 years in the past, then Money assumes that the date is in the future and uses Year+2000. Dates are displayed in Microsoft Money consistent with the Windows date format setting. Years can be displayed as either 2 or 4-digit. Online Banking Services. OFX and OFC Money transmits date information to (and receives from) OFX and OFC using a 4-digit format (YYYYMMDD) within the operational date range for the Money product.   Checkfree: The Checkfree/ISC/NPC 4.2 specification (dated 1/23/1996) specifies the data format for communications with Checkfree. Checkfree uses six numeric digits to represent dates as YYMMDD. Money and Checkfree exchange and translate 2-digit years during Online Banking connections using the following algorithm: If YY = 00 it is considered 20__ __ If YY < 93, it is considered 20__ (e.g., 2092) If YY >= 93, it is considered 19__ (e.g., 1993) Applying this formula, the operational date range for Money in connection with online bill payment services with Checkfree is 1/1/1993 to 12/31/2092. ANSER-SPC Money transmits date information to (and receives from) ANSER-SPC without year information. When Money receives date information without year, Money uses a heuristic rule and treats either as current year or as previous year. If the day in the downloaded statements is in the future, Money assumes that the date is from last year. Money Support for QIF Protocol. Microsoft Money supports the QIF data transfer protocol developed by Intuit. Most versions of QIF have represented dates using a two-digit year format. While the data stored in Money is Y2K compliant, Money needs to use a heuristic to determine the best two-digit date to use when importing to or exporting from the QIF format. The heuristic compares the 2-digit year that is being imported to the current year. If the Year+1900 is more than 33 years in the past, then Money assumes that the date is in the future and uses Year+2000. In some versions, QIF uses an apostrophe to denote specific date ranges (for example 1/31Æ01 ). In Quicken 98, it is used to indicate the years from 1900 û 1949 and 2050 û 2099. In versions prior to Quicken 98, in Quicken 99, and in Money v. 4.0 and up, an apostrophe is used to indicate the years from 2000 û 2099. Dates in the apostrophe format will be interpreted with the same heuristic as other valid QIF date formats. Users must use the Windows date format of MM/dd/YY format when they import and export QIF files using US Money 2000. This mm/dd/yy system date format is required when importing and exporting QIF according to IntuitÆs Quicken QIF Y2K statement. Presented below is a table describing how Money interprets QIF data ranges: US Money2000: Transaction Dates in Money Exported to QIF as 1/1/1948-12/31/1965 M/d/yyyy 1/1/1966-12/31/1999 M/D/yy 1/1/2000 to 12/31/2065 M/DÆyy 1/1/2066 -12/31/2200 M/DÆYYYY QIF Dates Imported into Money as MM/DD/YY 1/1/00 û 12/31/99 1/1/1966 û 12/31/2065* MM/DDÆYY 1/1Æ00 û 12/31Æ99 1/1/1966 û 12/31/2065* Invalid Date Blank Date MM/DD/YYYY or MM/DDÆYYYY 1/1/1900 û 12/31/2200 * These date ranges will change as TodayÆs date changes according to the heuristic Money uses.

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.