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

How to display a date range

Started by vinch999, 28 Mar 2011 07:11:17 AM

Previous topic - Next topic

vinch999

Hi,
I have an interval date prompt on the prompt page.

I want to display the selected date range on a graphic title.
(example: From 1 April To 5 April)

When I insert the DATE, I only have the start date

How to display the end date too?

cheers, vinc

jcrouch

Hi,

When you use a Date Prompt with the range property set to Y the paramater will be set to something like this:

Between Mar 8, 2011 and Mar 28, 2011

So you could set your Text Item's Report Expression to:

ParamDisplayValue('parameterName')

If you needed it to say From instead of Between you can use some string functions to change it.

Jeremy

vinch999

Sorry , I just found the solution by myself!  ;D

How to:

-Add a text
-source type: report expression
-report expression: ParamDisplayValue('Parameter')

8)