Function:  

LAST_DAY_OF_MONTH  

Description:  

Calculates the date that corresponds to the last day of month of the provided date  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date  

Example:  

IF LAST_DAY_OF_MONTH (Account.OpeningDate=31/10/2004) Then …

   

Function:  

LAST_DAY_OF_NEXT_MONTH  

Description:  

Calculates the date that corresponds to the last day of next month of the provided date  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date  

Example:  

IF LAST_DAY_OF_NEXT_MONTH (Account.OpeningDate=30/11/2004) Then …

   

Function:  

LAST_DAY_OF_PREV_MONTH  

Description:  

Calculates the date that corresponds to the last day of the previous month of the provided date.  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date  

Example:  

IF LAST_DAY_OF_PREV_MONTH (Account.OpeningDate=30/09/2004) Then …

   

Function:  

MINUTE  

Description:  

Returns the minute of the provided date as an integer constant in the range 0-59  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date  

Example:  

IF MINUTE (Account.OpeningDate=45) Then …

   

Function:  

MINUTES  

Description:  

Returns an integer constant indicating the number of minutes in the provided duration  

Parameters:  

Attribute of the Duration type or duration constant or calculation producing duration  

Example:  

If  MINUTES (Task.Duration) =  5 Then …

   

Function:  

MONTH  

Description:  

Returns the month of the provided date as an integer constant in the range 1-12  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date  

Example:  

IF MONTH (Account.OpeningDate=12) Then …

   

Function:  

MONTH_ADD  

Description:  

Returns the date resulting from adding/subtracting the specified number of months to the specified date  

Parameters:  

An expression producing date and an expression producing a number to be added or subtracted (if the number is negative) to the date