How to extract month a from a date and display it as a string in Report studio

Technote (troubleshooting)


Problem(Abstract)

How to extract month from a date field and display it as a string in Cognos 8.

Resolving the problem

extract(month,[date data item]) gives the numeric value of a month.(example : 8 for August)

To display it as a string ('August', for example) there are several solutions:

1) Before extracting, change the date format of the date data item to date and date style to Long. Now select 'no' to display years,weekdays and days. Select yes to display months. This when run gives the date displayed as month name.

2) Use a Case Statement

case extract(month,[Order date])
when 1 then 'January'
when 2 then 'February'
when 3 then 'March'
when 4 then 'April'
when 5 then 'May'
when 6 then 'June'
when 7 then 'July'
when 8 then 'August'
when 9 then 'September'
when 10 then 'October'
when 11 then 'November'
when 12 then 'December'
else 'error'
end

3) Use one of the vendor specific functions depending on the database.

See the attached reportspec using Gosales and Retailers .

Related information

KB 1019996: How do I extract the year and/or month from a date field using Cognos 8?

Historical Number

1029704

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos 8 Business Intelligence
Report Studio

Software version:

8.3, 8.4, 8.4.1, 10.1, 10.1.1

Operating system(s):

Solaris, Windows

Reference #:

1341546

Modified date:

2012-07-18

Translate my page

Machine Translation

Content navigation