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

Date Prompt with Pass-Through SQL to Oracle

Started by hauge9, 16 Sep 2008 02:48:10 PM

Previous topic - Next topic

hauge9

I have a report built off of a pass-through SQL statement to Oracle. The query uses Start and End date parameters. Currently, I am sending strings to the SQL and converting the strings to dates. So the users have to enter strings in the correct format (e.x. 01-01-2008 05:00:00). This is what my parameter looks like in the SQL:

to_date(#prompt('start_time')#,'MM-DD-YYYY HH24:MI:SS')

I am trying to be able to use the Cognos date selector instead of having the user input strings. Anyone know how to do this? Thanks a lot.