Function:  

AGE  

Description:  

Returns the full year difference between the provided date and the current date  

Parameters:  

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

Example:  

IF Age (Account.Customer.DateOfBirth) > 70 Then …

   

Function:  

BUSINESS_DAY_FORWARD  

Description:  

Calculates the date that corresponds to the first business day after the provided date. Business days are usually those that do not include weekends and public holidays. The list of public holidays may be provided in the “PublicHolidays” property of the server property file.  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date. The second parameter is optional – it indicates the number of days to move forward. If omitted, one day is assumed.  

Example:  

IF CURRENT_DATE=BUSINESS_DAY_FORWARD (Account.OpeningDate) Then …

   

Function:  

BUSINESS_DAY_BACK  

Description:  

Calculates the date that corresponds to the first business day before the provided date. Business days are usually those that do not include weekends and public holidays. The list of public holidays may be provided in the “PublicHolidays” property of the server property file.  

Parameters:  

Attribute of the Date type or date constant or calculation producing a date. The second parameter is optional – it indicates the number of days to move back. If omitted, one day is assumed.  

Example:  

IF CURRENT_DATE=BUSINESS_DAY_BACK (Account.OpeningDate) Then …

   

Function:  

CURRENT_DATE  

Description:  

Returns current date as the date constant  

Parameters:  

None  

Example:  

Account.OpeningDate = CURRENT_DATE

   

Function:  

CURRENT_TIMESTAMP  

Description:  

Returns current date and time as the timestamp

Parameters:  

None  

Example:  

Transaction.Time = CURRENT_TIMESTAMP

   

Function:  

CURRENT_DAY_OF_YEAR  

Description:  

Returns current day of the year as an integer constant in the range 1-366  

Parameters:  

None  

Example:  

IF CURRENT_DAY_OF_YEAR = 8 Then …

   

Function:  

CURRENT_DAY_OF_MONTH  

Description:  

Returns current day of the month as an integer constant in the range 1-31  

Parameters:  

None  

Example:  

IF CURRENT_DAY_OF_MONTH = 8 Then …

   

Function:  

CURRENT_DAY_OF_WEEK  

Description:  

Returns current day of the week as a string constant (‘Monday’, ‘Tuesday’, etc)  

Parameters:  

None  

Example:  

IF CURRENT_DAY_OF_WEEK = ‘Saturday’ Then …

   

Function:  

CURRENT_MONTH  

Description:  

Returns current month as an integer constant in the range 1-12  

Parameters:  

None  

Example:  

IF CURRENT_ MONTH = 1 Then …

   

Function:  

CURRENT_YEAR  

Description:  

Returns current year as an integer constant  

Parameters:  

None  

Example:  

IF CURRENT_YEAR = 2004 Then …

   

Function:  

CURRENT_WEEK  

Description:  

Returns current week as an integer constant in the range 1-52  

Parameters:  

None  

Example:  

IF CURRENT_WEEK = 1 Then SEND GreetingEmail TO Customer

   

Function:  

CURRENT_HOUR  

Description:  

Returns current hour as an integer constant in the range 0-23  

Parameters:  

None  

Example:  

IF CURRENT_HOUR = 12 Then DISPLAY MESSAGE ‘Midday!’

   

Function:  

CURRENT_MINUTE  

Description:  

Returns current minute as an integer constant in the range 0-59  

Parameters:  

None  

Example:  

IF CURRENT_MINUTE = 45 Then …