User Guide

Return Value/ExampleData TypeFunction
Returns the seconds (0-59) of the current time or a given time. The given time must
be a floating-point value, as returned by the time function. tests whether the current
time is within the last ten seconds of a minute.
Integersecond [ (time) ]
Returns the current system time or the time portion of a date-time value. The given
time can be a floating point value, a string of the form hh:mm:ss, or two or three
Floattime [ (time) ]
numeric values: hh, mm [, ss ]. (with no arguments) returns the current time. tests
whether the current time is after 2:00 PM.
Returns the current day of week (Sunday=1, Monday=2, etc.) of the current date or
given date. The given date must be an integer or floating-point value, as returned by
the date or now function. tests whether today is Tuesday.
Integerweekday [ (date) ]
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.
Andyear [ (date) ]
Mathematical Functions
The following table lists the built-in mathematical functions:
Return Value/ExampleData TypeFunction
Returns the absolute value of (the number with no sign).
returns the value 15.
Floating Point or Integerabs(n)
Returns the largest of the operands. Each operand must be
numeric. returns the value 3.
Floating Point or Integermax(n1, n2 [,n3] . . .)
Returns the smallest of the operands. Each operand must be
numeric. returns the value -2.
Integermin(n1, n2 [,n3] . . .)
Returns the integer remainder of n1 divided by n2. returns
the value 99.
Floating Point or Integermod(n1,n2)
Returns a random value between 0 and 1.Floating Point or Integerrandom()
Returns the square root of . (The operand n must be numeric
and non-negative.) returns the value 7.
Floating Point or Integersqrt(n)
Returns the value of truncated to an integer. returns the value
28.
Floating Point or Integertrunc(n)
Miscellaneous Functions
The following table lists the built-in miscellaneous functions:
Return Value/ExampleData TypeFunction
That portion of string2 following the first occurrence of string1.
If string1 does not occur in string2, the null string is returned. If
Stringafter(string1,string2)
string1 is the null string, string2 is returned. returns the value
defg.
Scripting and Media Routing Guide Cisco Unified ICM/Contact Center Enterprise & Hosted Release 7.5(1)
142
Chapter 7: Using Formulas
Variables