German Reports in Microsoft Excel Format Contain Incorrect Dates (226500)
The information in this article applies to:
- Microsoft Site Server 3.0
This article was previously published under Q226500 Note: The information in this article applies to the German version of Site Server 3.0
SYMPTOMS
In the German version of Report Writer, all reports that are saved in Microsoft Excel format contain a wrong date for "Datum der analyse," "Erstes Datum analysiert," and "Letztes Datum analysiert."
CAUSE
The date is transferred as a serial number, and then formatted as a date in Microsoft Excel. For example, the date 1/18/99 is converted to 180199, which appears as "15.05.2393" when formatted as a date in Microsoft Excel (German).
RESOLUTIONTo resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
219292 How to Obtain the Latest Site Server 3.0 Service Pack
STATUS This problem was first corrected in Site Server 3.0 Service Pack 3.
Modification Type: | Major | Last Reviewed: | 5/8/2002 |
---|
Keywords: | kbbug KB226500 |
---|
|