Print Page - change the numeric date format to character date format

Title: change the numeric date format to character date format
Post by: sunny8 on 27 Aug 2011 05:09:06 AM

hi
I have a column which shows month & year as 01/2011, 02/2011.........and so on
now i need to change this numeric format to character format by applying a date function in the column expression
can any one suggest me what query i can apply for that column to get the req; out put..
i mean the req; output for me is like Jan/2011, feb/2011.......and so on

Thanks in advance

Title: Re: change the numeric date format to character date format
Post by: lucasdnd on 30 Aug 2011 03:26:31 PM

If you have numeric values for Year and Month, I guess you could try this function:

_make_timestamp (x, y, z)
Where x = year, y = month and z = day.

Then, you can set the Data Format for this field to "Date" and format the way it shows on the report.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sunny8 on 27 Aug 2011 05:09:06 AM