Hi Team,
In my main query below filter is available, but i want to set the default date . I am little bit confused , how two date are passed in one parameter.
[Hiring Process].[Business Required Date].[Business Required Date].[Day].[Calender Date] in_range ?pTime?
if i want to set default date as from today's date to previous 3 months / 90 days.
Please suggest .
Best Regards,
Inam
Hi,
The in_range is the function from IBM cognos and the application produces the sql with >= and <= which is done on the application side and it will create 2 prompts. Setting the defaults as per your requirement is not possible with the cognos generated prompt. Will the report always will run for the same set of date parameters or will the users be selecting the dates too.
Good luck
New guy