Should not select future date

[kirru_alayam@yahoo.co.in]

Hi,

I have report with a prompt page. Prompt page contains a date range prompt (start date and end date).

I have requirement like Future date (05 apr 2016 onwards) should not display in the date prompt when I select 04 Apr 2016.

How to achieve this. Kindly help me.

Thanks,
Hari

[cognos-t]

Hi Hary,

you can use a filter in the underlying query for the promt with following syntax: [Date Item] <= current_date

Future dates will be filtered out dynamically.

Best regards

[kirru_alayam@yahoo.co.in]

Hi,

Thanks for your reply.

I have given like below in the filter for date range prompt..

([Presentation Layer].[Effective Date].[Effective Date].[Effective Date].[Effective Date] in_range ?dateRange?)<=current_date

But getting an error..

RSV-VALl-0010 failed to load the report specification. XQE-PLN-0164 The query is not supported. The argument at position 1 of '<=' used in a detailFilter can not be coerced into a 'value' expression.

Thanks,
Hari

[BigChris]

Hmmm...looks like you're using dimensional data, in conjunction with a detail filter - is that right?

If that's the case then you definitely should look to use a slicer instead.

[kirru_alayam@yahoo.co.in]

Yes Chris.. I am using DMR Model.

Thanks,
Hari