/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


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

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

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ