User input range of dates and times for a report

[genox]

Hi all

I'm very new to Actuate using Version 7 SP2 and trying to do a report where the user inputs a date and time range to restrict the returned information. I managed to get a range returned between 2 dates only by using the adhoc conditions tab in Textual Query Editor but cannot find a way of allowing users to input times and dates as well at runtime.

The date source is an Oracle 8 db:

SELECT job_no, job_desc
FROM workorder
WHERE order_date BETWEEN &order_date AND &order_date;

order_date is a date datatype with time and date information

I'm sure there must be a easy way to do this but I am stuck at the moment.

Any help greatly appreciated!

 

[Gamecock]

Write a .asp page and input the date and time into a table. Then read the table and write the date and time to a varible. Then use the varibles in your sql.

Hope this helps.