Microsoft KB Archive/250046

= Works: Numeric-Only Date Format Is Not Available =

Article ID: 250046

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001

-



This article was previously published under Q250046



SYMPTOMS
When you add a date field to a Works database, a numeric-only date format may not appear in the Appearance box.

Only a series of alphanumeric date formats may appear in the Appearance box, as in the following example:


 * 17-Jan-00
 * 17-Jan
 * Jan-00
 * January 17, 2000
 * January 2000
 * January 17
 * January



CAUSE
This behavior can occur if the short date style is set to dd-MMM-yy in the Regional Settings tool in Control Panel.



RESOLUTION
To resolve this issue, select a different short date style:
 * 1) Quit Works.
 * 2) Click Start, point to Settings, and then click Control Panel.
 * 3) Double-click Regional Settings.
 * 4) Click the Date tab.
 * 5) In the Short date style box, click any date style other than dd-MMM-yy.
 * 6) Click OK, and then close Control Panel.

Additional query words: w_works works2k w2001 dates field only numbers

Keywords: kbenv kbprb kbui KB250046

-

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

© Microsoft Corporation. All rights reserved.