SELECT taskdet.TASKID AS "Task ID", taskdet.TITLE AS "Title", taskowner.FIRST_NAME AS "Owner", taskdet.MODULE AS "Module", wotask.WORKORDERID AS "Request ID", taskprob.PROBLEMID AS "Problem ID", taskchange.CHANGEID AS "Change ID", taskproject.PROJECTID AS "Project Id",rctd.FIRST_NAME AS "Worklog Owner",LONGTODATE(ct.TS_STARTTIME) AS "Worklog Start time", LONGTODATE(ct.TS_ENDTIME) AS "Worklog End time", ct.DESCRIPTION AS "Worklog Description" FROM TaskDetails taskdet LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID LEFT JOIN WorkOrderToTaskDetails wototaskdet ON taskdet.TASKID=wototaskdet.TASKID LEFT JOIN WorkOrder wotask ON wototaskdet.WORKORDERID=wotask.WORKORDERID LEFT JOIN ProblemToTaskDetails probtotaskdet ON taskdet.TASKID=probtotaskdet.TASKID LEFT JOIN Problem taskprob ON probtotaskdet.PROBLEMID=taskprob.PROBLEMID LEFT JOIN ChangeToTaskDetails changetotaskdet ON taskdet.TASKID=changetotaskdet.TASKID LEFT JOIN ChangeDetails taskchange ON changetotaskdet.CHANGEID=taskchange.CHANGEID LEFT JOIN TaskToProjects projtotaskdet ON taskdet.TASKID=projtotaskdet.TASKID LEFT JOIN ProjectDetails taskproject ON projtotaskdet.PROJECTID=taskproject.PROJECTID LEFT JOIN TaskToCharge toc ON taskdet.TASKID = toc.TASKID LEFT JOIN ChargesTable ct ON toc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID WHERE (taskdet.CREATEDDATE >= <from_thismonth>) AND (taskdet.CREATEDDATE <= <to_thismonth>)

In the above query, you can replace the <from_thismonth> and <to_thismonth> with the desired date filter. You can look for the available list of date filters here - Date Filter