FP2000: Time Stamp in Database Form Handler Shows Two-Digit Year (219124)

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:

On the Windows Start menu, point to Settings, and click Control Panel.
Double-click the Regional Settings icon.
Click the Date tab.
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:

M/d/yy	M/d/yyyy
6/8/81	6/8/1981
6/8/99	6/8/1999
6/8/00	6/8/2000
6/8/2099	6/8/2099

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