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

Dynamically defaulting the date range prompt

Started by chandanrock, 01 May 2014 12:07:29 PM

Previous topic - Next topic

chandanrock

Hi All,
I have tried for a solution but failed to get one.

I am using Cognos 10.1 and there is a requirement to default the dates in the date range prompt to 'first of last month' and the 'last of last month'.
Please note im using the following filter in the query --- [Date] in_range ?date?.

For example.
If i am running the report on 'May 1st', the date on the prompt should show 'from date' = apr 01 and 'to date' = 30th apr.

Thanks for your help.
Naga