Help with Aged Call

Hi,

I have been asked to produce a report that listed all of the open\pending request and list the age in the number of days they have been open. I found where someone had attempted to this before, but I can not getting it working. Keeps returning blank screens. Our database is a sql server.

Anyone able to help?

SELECT wo.WORKORDERID "Request ID",wo.DESCRIPTION "Description",td.TASKID "TaskId",td.TITLE "Task Title",aau.FIRST_NAME "Requester",au1.FIRST_NAME "Task Owner",no.NOTESTEXT "Notes" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos on wos.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrdertoTaskDetails wtt on wtt.WORKORDERID=wo.WORKORDERID LEFT JOIN TaskDetails td on td.TASKID=wtt.TASKID LEFT JOIN SDUser sdu on sdu.USERID=wo.REQUESTERID LEFT JOIN AaaUser aau on aau.USER_ID=sdu.USERID LEFT JOIN SDUser sdu1 on sdu1.USERID=td.OWNERID LEFT JOIN AaaUser au1 on au1.USER_ID=sdu1.USERID LEFT JOIN StatusDefinition sd on sd.STATUSID=wos.STATUSID LEFT JOIN Notes no on no.WORKORDERID=wo.WORKORDERID WHERE (wot.THD_WOID=wot.WORKORDERID) and sd.STATUSNAME='Open' and DATEADD(s,td.CREATEDDATE/1000,'01-01-1970') >= convert(varchar,<to_today>,21) and DATEADD(s,td.CREATEDDATE/1000,'01-01-1970 05:30') <= convert(varchar,<to_today>,21)

Cheers