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

Format Date Parameter in Report Heading

Started by kbasha2004, 07 May 2008 10:55:55 AM

Previous topic - Next topic

kbasha2004

Hi All,

I am using the in_range function(Schedule_Date in_range ?Sched_date?). I want to display the start and end dates of the date range. I tried the
ParamValue(?Sched_date?) dispalys value as '2008-04-01TO00:00:00:2008-04-30T11:59:00'.
In the properties section in Data Format, I tried Date/Time and formatted  but it is not working.

I want to display as 01-Apr-08 To 30-Apr-08 in Report Heading. How can I achieve this? Please help ---   I need this urgent.

Thanks,
KBasha

almeids

You can't do it with a range parameter.
If you keep the range parameter, you'll have to live with the formatting or use the min and max values of whatever date it is you are filtering on (which of course may not represent the full parameter range).
If the formatting is critical, you'll have to switch to separate start and end date parameters, then create data items out of each which can be formatted as desired on the report.