Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos 8 without date functions

Status
Not open for further replies.

mahali

Technical User
Jan 30, 2007
25
DE
Hi there,

just started with Cognos 8 Report Studio I am already facing some basic problems: all I would like to do is to show the current year. I tried with to_char(sysdate(), 'YYYY'), but that does not work and I cannot find any Cognos functions - I remember that there were year(), month() etc. functions in Impromptu, where have these gone???

Kind regards and have a great weekend,

Mahali
 
Hi there,

I have just figured out the solution: what I had done wrong was to use a ',' instead of a ';' between the date and the format 'YYYY' - now it works perfectly well :)

Kind regards,

Mahali
 
Hi,

Another solution using Cognos 8 functions would be:

extract(year, current_date)

Regards,

MF.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top