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.