SQL query help needed please

I have the following script that runs fine (Build 7009 on MSSQL 2000).

However I need to put a time limit on each select statement so that it only counts incidents created in the last month, but I am having difficulty as SDP does not use the standard SQL date format to store dates.

Can anyone help please?

This is the script:

SELECT p.priorityname PRIORITY,
isnull(nod.SLAI, '0') as "WITHIN_SLA",
isnull(od.SLAO,'0') as "FAILED_SLA",
isnull(cnt.cnt, '0') as "TOTAL"
FROM prioritydefinition p LEFT join

/* SELECT STATEMENT TO COUNT REQUESTS WITHIN SLA*/
(select wos.priorityid, count(*) SLAI
FROM WorkOrder_Threaded wot
LEFT JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
where wot.THD_WOID=wot.WORKORDERID and iSOVERDUE = '0'
group by wos.priorityid) nod on p.priorityid=nod.priorityid

left JOIN
/* SELECT STATEMENT TO COUNT REQUESTS OUT OF SLA*/
(select wos.priorityid, count(*) SLAO
FROM WorkOrder_Threaded wot
LEFT JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
where wot.THD_WOID=wot.WORKORDERID and iSOVERDUE = '1'
group by wos.priorityid) od on p.priorityid=od.priorityid

left JOIN
/* SELECT STATEMENT TO COUNT ALL REQUESTS*/
(select wos.priorityid, count(*) cnt
FROM WorkOrder_Threaded wot
LEFT JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
where wot.THD_WOID=wot.WORKORDERID and iSOVERDUE in('1','0')
group by wos.priorityid) cnt on p.priorityid=cnt.priorityid