Date Function

Date Function

Description:
Construct a date value from year, month and day component values.
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 )