Print Page - Date filter for Oracle database

Title: Date filter for Oracle database
Post by: cognos4321 on 23 Mar 2018 03:13:32 PM

Hi,
I need to create a report from a relational database(oracle)

There is a begin date column in the table, name: [Begin Date]
The business needs a Calendar prompt which would let them select any date , parameter name: 'pSelectedDate'
They want the cognos report to filter data on the condition :
[Begin Date] <='pSelectedDate'

When I put this expression in the detail filter area : [Begin Date] <=?pSelectedDate?
It doesn't give me any error but shows incorrect data.

Please help.
Thanks in advance.

Title: Re: Date filter for Oracle database
Post by: cognos4321 on 23 Mar 2018 04:25:39 PM

Just wanted to mention [Begin Date] is not just a single date field, it's the Column name.

Thanks in advance.

Title: Date filter in cognos for Oracle database
Post by: cognos4321 on 26 Mar 2018 09:14:30 AM

Please help.

This doesn't wok for me at all
[Begin Date] <='pSelectedDate'
where begin date is a date column.
Their formats are same mm/dd/yyyy

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos4321 on 23 Mar 2018 03:13:32 PM