Request -Task report

Query

G o to Reports > New Query Report, copy the below query to query editor and run the report.

SELECT wo.WORKORDERID "Request ID",LONGTODATE(wo.CREATEDTIME) "Created Time",aau.FIRST_NAME "Requester",wo.TITLE "Subject",std.STATUSNAME "Request Status",ti.FIRST_NAME "Technician",tk.TITLE "Task Title",tstd.STATUSNAME "Task Status", LONGTODATE(tk.SCHEDULEDSTARTTIME) "Task Scheduled Start Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID 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 StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrdertoTaskDetails wotk ON wo.WORKORDERID=wotk.WORKORDERID LEFT JOIN TaskDetails tk ON wotk.TASKID=tk.TASKID LEFT JOIN StatusDefinition tstd ON tk.STATUSID=tstd.STATUSID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN accountsitemapping asm ON asm.SITEID=siteDef.SITEID LEFT JOIN accountdefinition ad ON ad.ORG_ID=asm.ACCOUNTID

WHERE (wo.ISPARENT='1') AND wo.CREATEDTIME >= <from_thismonth> AND wo.CREATEDTIME <= <to_thismonth> and tk.taskid is not NULL and ad.org_id in ($Account)

This query apply to account which is selected in account combo box

How to compare date column with auto filled date templates?