Returns the current system date, which is controlled by the operating system, or creates a year 2000-compliant Date value.

DATE([nYear, nMonth, nDay])

Parameters

nYear

Specifies the year returned in the year 2000-compliant Date value. nYear can be a value from 100 to 9999.

nMonth

Specifies the month returned in the year 2000-compliant Date value. nMonth can be a value from 1 to 12.

nDay

Specifies the day returned in the year 2000-compliant Date value. nDay can be a value from 1 to 31.

Return Value

Remarks

Example

The following example displays the current system date with and without the century, and then displays a year 2000-compliant date.

	Copy Code
CLEAR SET CENTURY OFF ? DATE( ) && Displays today's date without the century SET CENTURY ON ? DATE( ) && Displays today's date with the century ? DATE(1998, 02, 16) && Displays a year 2000-compliant Date value

See Also