OFF95: Error or Unexpected Value Entering Custom Date Property
Article ID: 132237
Article Last Modified on 8/16/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft PowerPoint 95 Standard Edition
- Microsoft Word 95 Standard Edition
- Microsoft Project 4.1 Standard Edition
This article was previously published under Q132237
SYMPTOMS
In any of the Microsoft applications listed above, when you enter a custom
date value in the Properties dialog box for a document, one of the
following may occur:
CAUSE
This behavior occurs if you enter a date value earlier than 1/1/1601,
between 9/15/30829 and 5/8/31779, or later than 5/8/31779.
Earlier than 1/1/1601
If you enter a date earlier than 1/1/1601 (for example 5/3/1600), you
receive the error message described above, and the property is entered as a
Text type.
Between 9/15/30829 and 5/8/31779
If you enter a date between 9/15/30829 and 5/8/31779, such as 4/3/30999,
the property is entered as Unknown data type, and no value is entered in
the Value field for this property; the Value field is null.
Later Than 5/8/31779
If you enter a date later than 5/8/31779, a "random" date value appears in
the Value field for the property. For example, if you add a property as a
Date type with a value of 1/1/99999, the value 9/1/78 appears in the Value
field.
Keywords: KB132237