Get the last date from date range Cognos 8.4 Report Studio

[TechAbhiVaray]

All,

I have 6 queries in the report, with a date prompt with range; Three of those queries are grouped by date, hence i need the date range for those 3 queries.
However the other 3 only requires the last date from that range.
I have tried a range of options like maximum(date), however it still shows me a sum of all the dates.

Any help would be greatly appreciated.

Let me know if the question is vague and you need more information to answer the question.

 

[blom0344]

Use 2 date prompts 'begindate' / 'enddate' , so you can use the latter for the 3 queries you mention. The queries that use the range can then have a between filter using both parameter values

Ties Blom