On my prompt page I have a date prompt that allows the user to select a specific date for which info needs to be shown. I'm experiencing difficulties when on my query of the master report I put a selection that compares a date-time data type (in the Oracle table) to the date value parameter. Changing the date prompt to a date time prompt overcomes this issue, but I do not want the users to see the clock picture.
Can this be solved using a specific function at Report Studio query level? Please help.
I'm not sure if I understand your issue, but you may be able to resolve it either by using the "like" operator ( oracle_date like ?param?||'%' ) instead of "=", or by stripping the Oracle column down to date only ( trunc(oracle_date,'DDD') = ?param? ).
HTH
Steve
I have used this in the past...
to_date(to_char(yourDateTime,'YYYY-MM-DD'))