Hey I was just wondering if there is a way to set up a custom report for tickets closed in the month of June?  Usually we just run the built in report at the end of the month but this time we missed it.  Now we just need a report for the month of June.  I tried to create a custom report using the wizard but it's not giving me what I need.

Thanks.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
Easiest way is to use the report wizard, on the Filters screen set a filter criteria on say the 'Created' > May 31 23:59 and a second criteria < July 1 00:01. You can do a lot more using scripting but the wizard is quick and easy.
Answered 07/16/2015 by: Druis
Blue Belt

Please log in to comment
0
If it's already a SQL report then you can add the following to the where clause:
and YEAR(TIME_CLOSED) = 2015 and MONTH(TIME_CLOSED) = 06

Answered 07/17/2015 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share