Print Page - Extract Month from System date as 'January', 'February', etc

Title: Extract Month from System date as 'January', 'February', etc
Post by: Cognuser on 24 Jan 2011 10:53:57 AM

I am building a report in report studio and I need to extract the 'month' from the system date as one of my data items.

So if the system date is 'January 24, 2011' is want to extract 'January' and display this on my report.

When I use extract I only get the number 1???

Title: Re: Extract Month from System date as 'January', 'February', etc
Post by: MFGF on 24 Jan 2011 10:55:40 AM

Hi,

If you just need the day name to display, leave the date column intact, then use the Format option to define you want the day name to display and nothing else.

Regards,

MF.

Title: Re: Extract Month from System date as 'January', 'February', etc
Post by: Cognuser on 24 Jan 2011 11:35:34 AM

Thank you I will try that. Thank you for your quick response.

Title: Re: Extract Month from System date as 'January', 'February', etc
Post by: Mahendra on 03 Feb 2011 04:33:01 AM

Hi i think the below will help you,

Take a data item and place the to_char({sysdate},'MONTH')
code into expression window.
and use this where ever you require.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Cognuser on 24 Jan 2011 10:53:57 AM