Date and Time Formats

For date and number formats, an optional format pattern string can be specified. The date format pattern must conform to the patterns specified by the java.text.SimpleDateFormat class. For example, to format a date as 'Jan 01, 2000', use 'MMM dd, yyyy'.

Date and time formats can be specified at a number of levels:

1. Object Level: Date or time format applied to a specific report element (e.g., table column) using the Format tab of the Properties panel in Style Studio.

2. Report Level: Date or time format applied to a specific report using the 'Report Properties' dialog box in Style Studio. (See Report Properties.)

3. Data Model Level: Date or time format applied to a specific data field. (See Adding a Format to a Data Field in Data Modeling.)

4. Server Level: Default date or time format applied to all reports using the 'Presentation' page of Enterprise Manager. (See Presentation in the Administration Reference.)

5. Worksheet Level: Date or time format applied to a specific column in an Embedded Table in a Worksheet. (See Changing the Column Type in an Embedded Table in Data Mashup.)

The more specific formatting instruction overrides the more general formatting instruction. For example, the format applied to a particular report element (e.g., table) overrides any formatting specified at the report, model, or server levels.

Different geographical regions format dates differently. Instead of explicitly specifying a format for date fields, you can specify a Local Date format (e.g., 'Full', 'Long', 'Medium', 'Short') that automatically adapts itself to the locale of the reporting environment.

When no date or time format is found at any level (element, report, model, or server), an un-localized default format is used.

<< 7.5.1 Format Types © 1996-2013 InetSoft Technology Corporation (v11.5) Text Formats >>