/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


How do you set up a custom report for a particular month?

07/16/2015 1720 views
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


All 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
Third Degree Green Belt

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share