Microsoft KB Archive/60216

Works: Incorrect Date Formatting Due to Country Setting

PSS ID Number: Q60216 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SUMMARY =

If USA is not selected in the “Country:” field of the Options, Works Settings menu, the dates may be formatted as text, instead of being formatted in the date format. This results in incorrect sorting and querying with dates.

The problem results from choosing Canada (English), Canada (French), or Germany, for which the dates are separated with a period (.), instead of a forward slash (/).

If the settings are changed to USA, Australia, France, Mexico, or U.K., the dates will change to their proper format.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.