Date filter for Oracle database

[cognos4321]

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.

[cognos4321]

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


Thanks in advance.

[cognos4321]

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