COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: kbasha2004 on 07 May 2008 10:55:55 AM

Title: Format Date Parameter in Report Heading
Post by: kbasha2004 on 07 May 2008 10:55:55 AM
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
Title: Re: Format Date Parameter in Report Heading
Post by: almeids on 07 May 2008 11:59:43 AM
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.