Date and DateTime pattern and other format settings in FM and Reportnet

Technote (troubleshooting)


Problem(Abstract)

Unable to set a Date and DateTime pattern in Report Studio.

Error Message -

I18-FMT-0012 An error occurred while applying the format pattern

The specified localized pattern is invalid.

Resolving the problem

This error occurs when a format pattern entry is specified that is incorrect. For example, if the value of yyyy/dd/MM hh:mm:ss bb is set as the pattern the above error will be returned because the bb pattern value is invalid.

It is possible to specify an explicit format for Query Items in Framework Manager. This example will use the Date and DateTime format settings.

To change a displayed format for a Date or DateTime query item, select the item, then Properties, Format and "Click to Edit"

The Data Format selection will open with all the options of changing the the display format of the query item.

Note that the Pattern option will overrule some of the settings that you may have selected.

For instance, selecting the date to display AM/PM symbols and Two Digit Hours, Minutes and Seconds, and at the same time specifying a pattern as "MM/dd/yyyy" , will not give you the AM/PM and Hours, Minutes, Seconds part. The pattern will only give you the Month/Day/Year specified as pattern in that case.

For instance to have the date display as "2003/31/01 23:56:02 PM" the following pattern needs to be used : "yyyy/dd/MM hh:mm:ss aa"

Here is a quick table on the external standard for representation of the various items, as this may be difficult to locate. Note that some of these may not be implemented in ReportNet.

Symbol

Meaning

Presentation

Example

G

era designator

Text

AD

y

year

Number

1999

M

month in year

Text & Number

July & 07

d

day in month

Number

31

h

hour in am/pm (1-12)

Number

12

H

hour in day (0-23)

Number

0

m

minute in hour

Number

30

s

second in minute

Number

55

S

millisecond

Number

978

E

day in week

Text

Tuesday

D

day in year

Number

189

F

day of week in month

Number

2 (2nd Wed in July)

w

week in year

Number

27

W

week in month

Number

2

a

am/pm marker

Text

PM

k

hour in day (1-24)

Number

24

K

hour in am/pm (0-11)

Number

0

z

time zone

Text

Pacific Standard Time

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Install and Config
Business Analytics Cognos 8 Business Intelligence Report Studio
Business Analytics Cognos ReportNet ReportNet

Historical Number

1008135

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos ReportNet
ReportNet

Software version:

Cognos 8 BI Install and Config 8.1, Cognos 8 BI Report Studio 8.1, Cognos 8 BI Report Studio 8.2, Cognos ReportNet 1.1, Cognos ReportNet 1.1MR1, Cognos ReportNet 1.1MR2, Cognos ReportNet 1.1MR3, Cognos ReportNet 1.1MR4

Operating system(s):

All, Solaris, Win, Win32, Windows

Reference #:

1335552

Modified date:

2007-11-15

Translate my page

Machine Translation

Content navigation