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

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.


0 Comments   [ + ] Show comments

Answers (2)

Posted by: Druis 5 years ago
Third Degree Green Belt
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.
Posted by: chucksteel 5 years ago
Red Belt
If it's already a SQL report then you can add the following to the where clause:

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:


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