DATETIME keyword

Applies To

Form components with the data type DATE

Property defaults with the data type DATE

Component properties: Data type and format

Description

Specifies that the value of a component with the DATE data type consists of both a date and a time of day.

Syntax

DATETIME( )

Remarks

A component with the DATE data type can parse, validate, and display both date and time user input. The DATETIME keyword specifies that the component contains both a date and a time. If the user specifies only a time, the date defaults to December 30, 1999. If the user specifies only a date, the time defaults to 12:00 AM (Midnight). The date precedes the time, and the two are separated by a space. Example: 03/29/00 08:32:00 AM.

In the Windows client, if the Language field in the User Preferences window is set to <User Default Language Setting>, then the default formats for date and time follow the regional settings in the Windows Control Panel. In the web client, the default date and time formats are based on the Language settings of the browser.

You can override the default or regional settings by selecting a language in the User Preferences window. In the web client, you can change the Language settings of your browser. After you set the language, the date and time are formatted according to the standard notation for your chosen language.

In Ming.le, you can use the user preferences applet to override the language settings in Mongoose.

The value of a component returned by a script consists of both a date and a time in the format displayed in the component.

The keyword can serve as a parameter of the DEFAULTFORMAT keyword in data-type specifications. See DEFAULTFORMAT, TIME, and DATETIME in Related Topics.