Custom Kace report for a specific month
How do I modify the following canned report to not report on the last 31 days but the Month of April 2014?
select ifnull((select CUSTOM_2 from USER where HD_TICKET.SUBMITTER_ID = USER.ID),' External') as SUBMITTER_DEPT,
count(HD_TICKET.ID) AS Total_Requests
left join HD_STATUS on HD_STATUS_ID = HD_STATUS.ID
where HD_STATUS.STATE = 'closed' and HD_TICKET.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 31 DAY)
group by SUBMITTER_DEPT
order by SUBMITTER_DEPT