If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

get monthname from parameter .

Started by actcognosuser, 15 Jan 2010 09:07:02 AM

Previous topic - Next topic

actcognosuser

Hi all,
            I have a text item in my header with parameterdisplayvalue('enddate').

I want to display only the month in the selected end date .I applied dataformat in the text properties .It did not work.

Any suggestions?

Thanks in advance.

MFGF

Hi,

Instead of this, add a data item to your report query with the expression ?enddate?

Drop a Singleton into your page header, and set its Query property to point to your report query.

Then drop your data item into the singleton.

Finally select the data item, and use its Data Format property to format it as a date with only the long month name displayed.

MF.
Meep!

actcognosuser

Hi MFGF,
 
                 I added the dataitem with the expression?enddate?

The result was : 2014-08-09 T00:00:00.000.

When i run tabular SQL for that query it gives me 2014-08-09.Why am i getting these extra characters after the month????

MFGF

It's the time part of the datetime value.  Just ignore it - when you format the value as date and display only the long month name, you will not see it.

MF.
Meep!

actcognosuser

Hi MFGF,
                I still see the time .I set the dataformat to display longname for month.

actcognosuser


MFGF

Did you select a Data Format of Date or Date/Time?

Meep!