Filter
Top Products
13-35
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Formatting Reports in Interactive Viewer
Step 4 Click Apply.
Formatting Date and Time
The appearance of date and time data depends on the locale in which you are working. 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
Table 13-6 shows the standard date-and-time data type formats.
Step 1 Select a column that contains date or time data, then click Format.
The Date and Time Format window appears.
Step 2 In Format Date or Time As field, select the desired option.
Step 3 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 always 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.
Table 13-10 shows examples of custom formats and their effects on a date that is stored as 4/15/2006 in
the data source.