Cisco Systems CSACS3415K9 Manual De Usuario

Descargar
Página de 678
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