Microsoft KB Archive/219124

= FP2000: Time Stamp in Database Form Handler Shows Two-Digit Year =

Article ID: 219124

Article Last Modified on 10/1/2001

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q219124



SYMPTOMS
In FrontPage, if your "Save to Database" form includes the time stamp when the form was submitted, the time stamp is stored in two-digit year format.

Although the date appears in a two-digit format by default, the time stamp is still Year 2000 compliant.



CAUSE
FrontPage Database Results Form Handler uses the Visual Basic Scripting Edition (VBScript) value "Now" to store dates. The formatting of the value is solely dependent on the settings in the operating system that is hosting the page.

If you see the year in a two-digit format, it is because of the configuration of the Regional Settings on your computer.



RESOLUTION
To resolve this issue and see the year in a four-digit format, follow these steps:
 * 1) On the Windows Start menu, point to Settings, and click Control Panel.
 * 2) Double-click the Regional Settings icon.
 * 3) Click the Date tab.
 * 4) In the Short date style list, select M/d/yyyy and click Apply.

NOTE: When you return to your database, the year appears in a four-digit format.



MORE INFORMATION
When you view the time stamp field in your database, if a form was submitted after the year specified in the Regional Settings, the date field shows the four-digit year of the time stamp. The following table displays how various years appear in your database, based on the default regional settings of your computer:

Note that the year 2099 is written as a four-digit year. This is because the date is beyond the numbers specified in the When a two-digit year is entered, interpret as a year between box on the Date tab (Regional Settings dialog box).

Additional query words: front page y2k

Keywords: kbnofix kbprb KB219124

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.