Extracting Time Out of Impromptu

[thornbe]

I have a need to run a report and extract data (i.e. "Start Date/Time&quot from any give date 8:00am to 7:59am (following day). Is there a function that allows the extraction of Time only?

Thanks,

Tim H.

 

[nagrajm]

Add the following filter condition;

Start_Date_Time between to_date(concat(date-to-string(?Prompt?),' 08:00'),'DD/MM/YYYY HH24:MI') to to_date(concat(date-to-string(add-days(?Prompt?,1)),' 07:59'),'DD/MM/YYYY HH24:MI')

I have tested the code and it works, but for any reason if this gives an error check the 'DD/MM/YYYY HH24:MI' format to see if it should be say 'MM/DD/YYYY HH24:MI' instead.

Note : ?prompt? should be a date prompt and not date-time prompt.