13-60
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
WEEKDAY(date, option) Displays the day of the week in one of the following
format options:
• 1 - Returns the day number, from 1 (Sunday)
through 7 (Saturday). 1 is the default option.
• 2 - Returns the day number, from 1 (Monday)
through 7 (Sunday).
• 3 - Returns the day number, from 0 (Monday)
through 6 (Sunday).
• 4 - Returns the weekday name according to the
user’s locale.
• 5 - Returns the abbreviated weekday name
according to the user’s locale.
WEEKDAY([DateSold], 4)
WEIGHTEDAVERAGE
(value, weight)
Displays a weighted average of a specified value.
WEIGHTEDAVERAGE([Score], weight)
YEAR(date) Displays the four-digit year value for a
date-and-time value.
YEAR([ClosingDate])
Table 13-11 Examples of Functions (continued)
Function Description Example of use