how to use datatime prompt parameter in sql object

[anjidwh.cognos]

Hi,

I have a ?.... In my report i have datetime prompt, i am using this prompt parameter in SQL object on "recieved_date" column, which is having timestamp value.

To filter data based on timestamp values, i am using "to_date(#prompt('parameter')#,'yyyy-mm-dd hh:mi:ss')" macro on "recieved_date" column. But it is not accepting the parameter value.

Can anybody help me out.........Appriciated ur help!!

Thanks,
SR