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