Hi, Report help please -

Can't get my head round the date functions.

I need 2 columns adding to the below report:

• Days Since Last Tech Update (todays date - last_tech_update)
• Days since ticket logged (todays date - createdtime)

Preferably these 2 columns would return a whole number, rounding down.

Thanks very much in advance

SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", qd.QUEUENAME "Group", scd.NAME "Subcategory", icd.NAME "Item",wo.TITLE "Subject",longtodate(wo.CREATEDTIME) "Created Time",std.STATUSNAME "Request Status",rtdef.NAME "Request Type",longtodate(wos.LAST_TECH_UPDATE) "Last Updated 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 SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID
LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID
LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID

WHERE  (  ((std.STATUSNAME != N'Closed' AND std.STATUSNAME != N'Resolved') OR std.STATUSNAME IS NULL) AND (icd.NAME != N'Meeting Rooms'  OR icd.NAME IS NULL)     )  AND wo.ISPARENT='1'