Knowledge Base

BUG: SET CENTURY OFF is Ignored if Date is Over Year 2000

Article ID: 169471

Article Last Modified on 5/12/2003

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft Visual FoxPro 3.0b Standard Edition
Microsoft Visual FoxPro 5.0 Standard Edition
Microsoft Visual FoxPro 5.0a

This article was previously published under Q169471

SYMPTOMS

"SET CENTURY OFF" is ignored within text box of a form if the date type is set to "Taiwan" and the date is over "1/1/2000."

RESOLUTION

Convert the Date with the DTOC() function.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

In the Command window, type following commands:

SET DATE to Taiwan
SET CENTURY OFF
*** Note : Year 2000 is equivalent to Taiwan Year 0089
? {^2000-01-01}

"89/01/01" displays on the FoxPro desktop (or in the active window).

Place the same setting within a text box of a form and set the "Readonly" property to .F. The result is "0089/01/01."
Add a TextBox control within a form.
Change the property "Century" of the TextBox to "0 - Off."
Change the property "DateFormat" to "8 - Taiwan."
Change the "value" of the TextBox to {^2000-01-01}, which is January 1, 2000, and run the form.

NOTE: The display of the TextBox will be "0089/01/01." The TextBox value, however, is "89/01/01."

Keywords: kbbug KB169471