Date Prompt in Sql

[shrini]

Hi Team,

I have a problem with date promt implemetation in sql. The sql works fine, but when i use the same sql with report studio the date part is not working,hence it shows all records.

Here is the logic:-

trunc(date) <=TO_DATE ('20150724','YYYYMMDD')   in sql. It works fine

trunc(date)<=TO_DATE(#sq(prompt('Yr', 'Date'))#, 'YYYY-MM-DD')in report studio.

But when i include date prompt in sql with trunc(date)<=TO_DATE(#sq(prompt('Yr', 'Date'))#, 'YYYY-MM-DD'), the report shows all records, instead of the exact records.

Let me know your inputs, to solve this.

Thanks,
Shrini.