Cognos Date Range

[qberta01]

Hello,

I am using BI 8.4. What I would like to do is take a begin date prompt and an end date prompt ann list all the dates in between. So if someone chooses begin date = 8/1/2009 and end date = 8/5/2009; I would like to have a query that shows me:

8/1/2009
8/2/2009
8/3/2009.....

Is that possible?

thx,

Q.

 

[blom0344]

Yes,

In your dataquery reference the parameter values of the begin and enddate like:

[somedate] between cast([?begindate?,date) and cast([?enddate?,date)

where ?begindate? and ?enddate? are the parameters associated with the 2 prompts.

Ties Blom