Microsoft KB Archive/156009

From BetaArchive Wiki

Article ID: 156009

Article Last Modified on 3/14/2005



APPLIES TO

  • Microsoft Visual FoxPro 3.0b for Macintosh



This article was previously published under Q156009

SYMPTOMS

Dates entered into memory variables, date fields, or date and time fields without the century default to the 20th century (that is, 1900s). This behavior occurs even if the century in the Date and Time control panel is set to a year in the 21st century (that is, 2000s).

STATUS

This behavior is by design.

MORE INFORMATION

Visual FoxPro expects that "19" is the default for the century. The DATE() function reports the correct century, however, since it reads the system date.

Steps to Reproduce Behavior

  1. In the Macintosh Date and Time control panel, change the year to 2000 or anything later.
  2. In the Visual FoxPro Command window, enter the following commands and you get "05/15/05" on the Visual FoxPro desktop:

    SET CENTURY OFF
    x={05/15/05}
    ? x
                            
  3. Now enter the following commands in the Command window and you get "05/15/1905" on the Visual FoxPro desktop:

    SET CENTURY ON
    x={05/15/05}
    ? x
                            
  4. Remember to set the system date back to the correct date.


Keywords: kbprb KB156009