Time range for Help Desk tickets in reporting
I am working to create a report that will show tickets received between 1630 and 1800, Monday through Friday. Has anyone out there invented this wheel yet or have a suggestion on how to proceed?
I have tried Between with AND, greater than less than, it will work for one day, but not multiple days.
Thanks for any assistance.
If you have created a report that shows calls logged on Monday between your times, why not try and show the SQL and then duplicate the where statement for Monday, adding it in as an OR and changing the day to Tuesday. Which in effect will create an SQL statement that says....
Show me all calls where
The log time is Monday between A and B or
Tuesday between A and B or
Wednesday between A and B etc etc
Which may be a little cumbersome to build in a wizard, and I would sort by Day logged and break on days so it splits down to each day in the report