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.
Thanks.
Thanks.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
Druis
8 years ago
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
8 years ago
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
