How do I show data only for 0930 to 1700 on a report?

[dbaker2]

Help!!! I need to show data on a report for Mon through Fri, which I know how to do.However, I need to show only the buss. hours of 0930 to 1700 and I need this report to reoccur Mon through Fri. Our database logs info every 30 minutes from an ACD. We have 48 logging periods in the day which equals one logging period for every 30 minute interval with in the day. I know how to report for the last 30 minutes,
VW_PER_LOGGING."LOG_DATE".>SYSDATE -1/48
but dont know how to do the range between the logging periods. Thanks!

 

[synapsevampire]

Try something like the following in th record selection formula to get data returned for only those time periods:

time({VW_PER_LOGGING."LOG_DATE"}) in [time("09:30:00&quot to time("17:00:00&quot]

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com