Microsoft KB Archive/169471

From BetaArchive Wiki

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


"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."


Convert the Date with the DTOC() function.


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


Steps to Reproduce Behavior

  1. In the Command window, type following commands:

    SET DATE to Taiwan
    *** 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).

  2. Place the same setting within a text box of a form and set the "Readonly" property to .F. The result is "0089/01/01."
  3. Add a TextBox control within a form.
  4. Change the property "Century" of the TextBox to "0 - Off."
  5. Change the property "DateFormat" to "8 - Taiwan."
  6. 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