SELECT wo.WORKORDERID "Request ID",wo.TIMESPENTONREQ/3600000 "Time Spent",qd.QUEUENAME "Group",rc.MM2COMPLETEREQUEST/3600000 "Time Elapsed",rc.AMOUNT "Amount",longtodate(rc.DATETIME) "Cost entry date",longtodate(rc.EXECUTEDTIME) "Executed Time",rctd.FIRST_NAME "Technician",ti.FIRST_NAME "Assigned Technician",scd.NAME "Subcategory",icd.NAME "Item",wo.TITLE "Subject",rc.DESCRIPTION "Time Spent Description",wotodesc.FULLDESCRIPTION "Description",aau.FIRST_NAME "Requester",sdo.NAME "Site",ad.org_name"Account",rcode.NAME "Request Closure Code",cd.CATEGORYNAME "Category",wos.CLOSURECOMMENTS "Request Closure Comments",serdef.NAME "Service Category",dpt.DEPTNAME "Department",wos.REOPENED "ReOpened",pd.PRIORITYNAME "Priority",sinfo.WORKSTATIONNAME "Workstation",lvd.LEVELNAME "Level",mdd.MODENAME "Request Mode",std.STATUSNAME "Request Status",std.ISPENDING "Pending Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.RESPONDEDTIME) "Responded Date",longtodate(wo.COMPLETEDTIME) "Completed Time",rrs.RESOLUTION "Resolution" FROM WorkOrder wo LEFT JOIN RequestCharges rc ON wo.WORKORDERID=rc.WORKORDERID LEFT JOIN RCTechnicianIDs rct ON rc.REQUESTCHARGEID=rct.REQUESTCHARGEID LEFT JOIN SDUser rcti ON rct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN ServiceDefinition serdef ON wo.SERVICEID=serdef.SERVICEID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN SystemInfo sinfo ON wo.WORKSTATIONID=sinfo.WORKSTATIONID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN RequestClosureCode rcode ON wos.CLOSURECODEID=rcode.CLOSURECODEID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID LEFT JOIN accountsitemapping asm ON asm.SITEID=siteDef.SITEID LEFT JOIN accountdefinition ad ON ad.ORG_ID=asm.ACCOUNTID

WHERE   wo.CREATEDTIME >= <from_thismonth> AND wo.CREATEDTIME <= <to_thismonth>

AND wo.ISPARENT='1'

How to compare date column with auto filled date templates?

1. Here is the example for getting this week data - CREATEDTIME >= <from_thisweek> AND CREATEDTIME <= <to_thisweek>
• <from_thisweek> - Starting date of this week
• <to_thisweek> - Ending date of this week
2. Available Date Templates
• Today - <from_today> - <to_today>
• This week - <from_thisweek> - <to_thisweek>
• Last week - <from_lastweek> - <to_lastweek>
• This month - <from_thismonth> - <to_thismonth>
• Last month - <from_lastmonth> - <to_lastmonth>
• This quarter - <from_thisquarter> - <to_thisquarter>
• Last quarter - <from_lastquarter> - <to_lastquarter>
• Yesterday - <from_yesterday> - <to_yesterday>