Microsoft KB Archive/250046

From BetaArchive Wiki
Knowledge Base

Works: Numeric-Only Date Format Is Not Available

Article ID: 250046

Article Last Modified on 1/27/2007


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

This article was previously published under Q250046


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


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


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