Microsoft KB Archive/217034

= PRB: Two Digit Year Display of Date Fields in SQL Enterprise Manager (SEM) =

Article ID: 217034

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q217034



SYMPTOMS
Dates between 1930 and 2029 display in the SQL Enterprise Manager using only the last two digits of the year, while all other years are displayed in their entirety.



CAUSE
Enterprise Manager adopts the User's regional settings for the date format. By default, the regional setting for the short date format is M/d/yy.

RESOLUTION
On the taskbar, click the Start button, point to Settings and then select Control Panel. In the Control Panel dialog box double-click Regional Settings. In the Regional Settings Properties dialog box, select the Date tab. Next, change the value for the Short Date Style from M/d/yy to M/d/yyyy.

Additional query words: Y2K MMC KB2000 Y2Kreviewed

Keywords: kbbug kbprb KB217034

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.