13-35
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Formatting Reports in Interactive Viewer
Step4 Click Apply.
Formatting Date and Time
The appearance of date and time data depends on the locale in which you are work ing. For example, the
following date and time are correct for the U.S. English locale for Pacific Standard Time zone:
March 5, 2007 11:00:00 AM PST
The following example shows the same date and time for a French (France) locale:
5 mars 2007 11:00:00 HNP (ÈUA)
In a date-and-time column, a data source can provide both a date and a time, or only the date, or only the
time. If the data source provides both date and time data, you can format the column to display only a
date, only a time, or both a date and a time. You also can select the exact format for the date or time. For
example, if the data column displays the following value:
April 3, 2006 11:35 a.m.
selecting the Short Date format for the column displays only the date portion of the data, in the following
format:
4/3/06
Table13-6 shows the standard date-and-time data type formats.
Step1 Select a column that contains date or time data, then click Format.
The Date and Time Format window appears.
Step2 In Format Date or Time As field, select the desired option.
Step3 Click Apply.
Formatting Custom Date and Time
You can set custom date formats. Use custom date formatting, however, only if your report will be
viewed in a single locale. Custom formats always display dates in the format you set and that format
might not be clear in multiple locales.
For example, if you use the format MM-dd-yy, the date January 10, 2006 a lways appears as 01-10-06,
regardless of the locale in which the report is viewed. For locales in which dates are displayed in
date-month-year format, a 01-10-06 date is interpreted as October 1, 2006.
Table13-10 shows examples of custom formats and their effects on a date that is stored as 4/15/2006 in
the data source.