German Reports in Microsoft Excel Format Contain Incorrect Dates

ID: Q226500

The information in this article applies to:

Microsoft Site Server version 3.0

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).

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, please see the following article in the Microsoft Knowledge Base:

Q219292 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.

Additional query words: hotfix hot fix qfe quick engineering patch SS3SP2FIX

Keywords : SS3SP3Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbbug