Function:  

FIRST_DAY_OF_MONTH  

Description:  

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

Parameters:  

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

Example:  

IF FIRST_DAY_OF_MONTH (Account.OpeningDate=01/10/2004) Then …

   

Function:  

FIRST_DAY_OF_NEXT_MONTH  

Description:  

Calculates the date corresponding to the first day of the next month of the provided date  

Parameters:  

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

Example:  

IF FIRST_DAY_OF_NEXT_MONTH (Account.OpeningDate=01/11/2004) Then …

   

Function:  

FIRST_DAY_OF_PREV_MONTH  

Description:  

Calculates the date corresponding to the first 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 FIRST_DAY_OF_PREV_MONTH (Account.OpeningDate=01/09/2004) Then …

   

Function:  

FULL_YEARS  

Description:  

Calculates the number of full years between the two dates as an integer constant. Full year difference between 31/12/2004 and 01/01/2005 is 0  

Parameters:  

Two attributes of the Date type or date constants or calculations producing date  

Example:  

If  FULL_YEARS (Account.OpeningDate, Account.ClosingDate) = 5 Then …

   

Function:  

HOUR  

Description:  

Returns hour of the provided date as an integer constant in the range 0-23  

Parameters:  

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

Example:  

IF HOUR (Account.OpeningDate=12) Then …

   

Function:  

HOURS  

Description:  

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

Parameters:  

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

Example:  

If  HOURS (Task.Duration) =  5 Then …