Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Date Functions

EndOfMonth Function

EndOfMonth Function

Description 1 of 2 (the last day of the month as a number):
The number of days in the given month and year.
Returns:
Whole Number
Parameters:
Parameter
Data Type
Description
1
Whole Number
The month.
2
Whole Number
The year.
Examples:
When using functions inside a field, remember the field brackets:
{EndOfMonth(AgreementDateMonth, AgreementDateYear)}
Expression
Result
EndOfMonth( 2, 2000 )
29
EndOfMonth( 2, 2001 )
28
Description 2 of 2 (the last day of the month as a date):
The date which is the last day in the same month as the given date.
Returns:
Date
Parameter:
Parameter
Data Type
Description
1
Date
The date.
Examples:
When using functions inside a field, remember the field brackets:
{EndOfMonth(VariableName)}
Expression
Result
EndOfMonth( Date( 2001, 2, 1 ) )
Date( 2001, 2, 28 )
EndOfMonth( Date( 2001, 2, 28 ) )
Date( 2001, 2, 28 )
EndOfMonth( Date( 2000, 2, 28 ) )
Date( 2000, 2, 29 )

This article applies to:

  • Product: Contract Express