Cisco Cisco Unified Contact Center Enterprise 9.0(2) Release Note
Built-in Functions
Date and Time Functions
The following table lists the built-in date and time functions:
Return Value/Example
Data Type
Function
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
given date can be a floating point value (as returned by the now function), a string
Integer
date [ (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.
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: .
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.
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.
Integer
day [ (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.
a floating-point value, as returned by the now function. tests whether the current time
is before noon.
Integer
hour [ (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.
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.
Integer
minute [ (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.
be a floating-point value, as returned by the date or now function. tests whether the
current month is June.
Integer
month [ (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
time represented as a fraction. Note: You can use the date or time functions without
Float
now
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
.
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
.
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.
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.
Integer
second [ (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
time can be a floating point value, a string of the form hh:mm:ss, or two or three
Float
time [ (time) ]
numeric values: hh, mm [, ss ]. (with no arguments) returns the current time. tests
whether the current time is after 2:00 PM.
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.
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.
Integer
weekday [ (date) ]
ICM Scripting and Media Routing Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)
147
Chapter 7: Using Formulas
Variables