This article applies to:

Date Function

Description:

Construct a date value from year, month and day component values.

note

This function is non-evaluable if the year, month and day do not correspond to a valid date.

Returns:

Date

Parameters:

Parameter	Data Type	Description
1	Whole Number	The year in the range 1600 to 3999.
2	Whole Number	The month in the range 1 to 12.
3	Whole Number	The day of the month in the range 1 to EndOfMonth( yyyy, mm ) .

Examples:

When using functions inside a field, remember the field brackets:

{Date(VariableName)}

Expression	Result
Date( 2000, 2, 29 )	Date( 2000, 2, 29 )
Date( 2 * 1000, 6 // 3, 20 + 3 + 3 + 3 )	Date( 2000, 2, 29 )