Cisco Cisco IPCC Web Option Release Note

Page of 269
Return Value/Example
Data Type
Function
Returns the year of the current year or given date. The given date must be a
floating-point value, as returned by the date or now function. tests whether the
millennium has passed.
And
year [ (date) ]
Mathematical Functions
The following table lists the built-in mathematical functions:
Return Value/Example
Data Type
Function
Returns the absolute value of (the number with no sign).
returns the value 15.
Floating Point or Integer
abs(n)
Returns the largest of the operands. Each operand must be
numeric. returns the value 3.
Floating Point or Integer
max(n1, n2 [,n3] . . .)
Returns the smallest of the operands. Each operand must be
numeric. returns the value -2.
Integer
min(n1, n2 [,n3] . . .)
Returns the integer remainder of n1 divided by n2. returns
the value 99.
Floating Point or Integer
mod(n1,n2)
Returns a random value between 0 and 1.
Floating Point or Integer
random()
Returns the square root of . (The operand n must be numeric
and non-negative.) returns the value 7.
Floating Point or Integer
sqrt(n)
Returns the value of truncated to an integer. returns the value
28.
Floating Point or Integer
trunc(n)
Miscellaneous Functions
The following table lists the built-in miscellaneous functions:
Return Value/Example
Data Type
Function
That portion of string2 following the first occurrence of string1.
If string1 does not occur in string2, the null string is returned. If
String
after(string1,string2)
string1 is the null string, string2 is returned. returns the value
defg.
That portion of string2 that precedes the first occurrence of
string1. If string1 does not occur in string2, string2 is returned.
String
before(string1,string2)
If string1 is the null string, the null string is returned. returns the
value abc.
Indicates whether the CLID for the current contact is in the
geographical region specified by string. The value string must be
Logical
ClidInRegion
the name of a defined region. You can use the Name variable of
a region to avoid entering a literal value. tests whether the CLID
is from the Maryland region.
Returns the concatenation of the arguments. The function takes
up to eight arguments. returns the value abcde.
String
concatenate(string1,string2, . . .)
ICM Scripting and Media Routing Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)
148
Chapter 7: - Using Formulas
Variables