Microsoft KB Archive/250046

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:14, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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