User Guide

OperatorsOperator typePriority
^Bitwise exclusive Or8
|Bitwise inclusive Or9
&&And10
||Or11
?Conditional12
,Sequential13
Built-in Functions
Date and Time Functions
The following table lists the built-in date and time functions:
Return Value/ExampleData TypeFunction
Returns the current system date or the date portion of a given date-time value. The
given date can be a floating point value (as returned by the now function), a string
Integerdate [ (date) ]
of the form mm/dd/yy, or three integers: yyyy, mm, dd. date (with no arguments)
returns the current date. = date(2001, 7, 15) tests whether the current date is July 15,
2001.
Note: Do not use the slash (/) character in defining a date function. Because it is the
division operator, the function would not return the results you are looking for. You
could enclose the argument within a string----but the preferred format is: .
Returns the day of month (1-31) for the current date or a given date. The given date
must be an integer or a floating-point value, as returned by the date or now function.
tests whether tomorrow is the first of the month.
Integerday [ (date) ]
Returns the hour (0-23) of the current time or a given time. The given time must be
a floating-point value, as returned by the now function. tests whether the current time
is before noon.
Integerhour [ (time) ]
Returns the minutes (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 in the second fifteen-minute interval after an hour.
Integerminute [ (time) ]
Returns the month (1-12) of the current month or a given date. The given date must
be a floating-point value, as returned by the date or now function. tests whether the
current month is June.
Integermonth [ (date) ]
Returns the current date and time, with the date represented as an integer and the
time represented as a fraction. Note: You can use the date or time functions without
Floatnow
any arguments to return just the current date or time. This function is useful for
comparing the current date and time to a specific point in time. to test whether the
current date and time is later than 10 P.M., December 24, 2001, use the expression
.
Scripting and Media Routing Guide Cisco Unified ICM/Contact Center Enterprise & Hosted Release 7.5(1)
141
Chapter 7: Using Formulas
Variables