1 date/time prompt 2 queries

[Laynlowz]

Hello,

my name is Ian and I have been working on cognac for roughly 3 months now. I am learning as I go so bare with me. I am creating a productivity tracker at work to track order selector mispicks and production numbers. I have 1 query that is made up of the user, item SKU,  QTY and date of the mispick. Then my other query is user, QTY picked, minutes picking. I have 2 list boxes on page 1 of my report page.


My question is I have 2 queries that use separate date fields. How do I use 1 date prompt when I run the report filter both of these tables?  I don't want to use 2 date prompts each time I run the report.
Again I am pretty new to cognos and even building queries so bare with me.

[BigChris]

Hi Ian,

You can certainly use your prompt field in both queries. Something along the lines of

Query1: [Date of MisPick] = ?DatePrompt?

Query2: [TransactionDate] = ?DatePrompt?