Hello
I have the following query:
select qd.QUEUENAME "Group",wof.UDF_CHAR5 "Weekly Meeting",qd.QUEUENAME "Group", ti.FIRST_NAME "Analyst",wo.WORKORDERID "Request ID",wo.TITLE "Subject",N.NOTESTEXT "Notes Text",wof.UDF_CHAR4 "Vendor_Name",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueByTime", longtodate(wos.last_tech_update) ,longtodate(N.NOTESDATE) "Notes Date" 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 WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID LEFT JOIN (SELECT N.* FROM NOTES N WHERE N.NOTESID IN (SELECT MAX(NTS.NOTESID) FROM NOTES NTS GROUP BY NTS.WORKORDERID) ) n on n.WORKORDERID = wo.WORKORDERID WHERE (wo.ISPARENT='1') and qd.queuename like '%Team%' ORDER BY 1
How can I get the difference between longtodate(wos.last_tech_update) and longtodate(wo.CREATEDTIME) in days?
Thank you!