How to use Date range prompt on a single date column

[Mahendra]

Hi gurus,

     In my report I have a date column, how to use date range prompt on the same column, can any body please help me its very urgent...


Thanks in Advance..


Mahi

[MFGF]

You will need your filter to use the in_range operator

eg

[your date field] in_range ?your parameter?

The date range prompt should then fulfil the start and end dates for the range.

Regards,

MF.

[Mahendra]

Thanks for ur quick replay,

  And in my report i have used the text box prompts to enter from date and to date,do i have to convert this to date format let me know please..


Thanks & Regards
Mahi

[MFGF]

The best idea usually is to use a date prompt rather than text prompts, but it's your choice.

Regards,

MF.

[Arpitagrawal9]

You can use to calender/date prompt so that User can directly choose the data and you wont have to convert it in any specific format.Cognos By default provides this prompt.
Hence once you have created both the prompts you can apple a filter in your report query with a condition like [Date] between ?StartDate? and ?EndDate?

Hope this helps:)

In case you still face any issue feel free to write me.