13-60
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging 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])
Table13-11 Examples of Functions (continued)
Function Description Example of use