Skip to main content
Date Functions

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 )

This article applies to:

  • Product: Contract Express

Related Content