Hi Guruss,
I am facing the issue like this . I have 2 prompts one is the value prompt which contains today.last week,last month these are all static choices and the second is date range i.e., date prompt. The user should select either this or that. I am tried all the ways in cognos. but no luck. Kindly suggest?
Regards,
Jahnavi
Hi in your first static prompt add another option titled User defined date.
then create a filter in your query in the following format
if(?staticprompt?=1) then (what ever date period you want it to be)
else if (?staticprompt?=2) then (what ever date period you want it to be)
else if(?staticprompt?=3) then (what ever date period you want it to be)
else (date field you are using for your date range prompt in_range ?Dateprompt?)
Hope it helps
Thanks its working fine with conditional formatting...