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.
Answers (1)
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
Comments:
-
Thanks for the input!
I had tried something like that in SQL, I will give it a go in the wizard too. I have been playing with it more since I asked and may answer my own question soon. - tmscott 4 years ago-
if not, why not post your SQL in here and we can take a look for you ;o) - Hobbsy 4 years ago
