If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Passing a Date Prompt paramater to a DataTime data type

Started by kwierinc, 21 Nov 2007 11:12:54 AM

Previous topic - Next topic

kwierinc

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.

almeids

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

rockytopmark

I have used this in the past...

to_date(to_char(yourDateTime,'YYYY-MM-DD'))