Hi, we are using the servicedesk module. I am grabbing the data from a query that I made through the reporting tool in managedengine. When I run that query in excel. everything comes through just fine with the exception of the date. It just come across as a 13 digit number.
I am using Excel 2016 and the number is random but below is an example of the number minus the quotes.
"1516904434148"
Below is the query I am running...
SELECT "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", "icd"."NAME" AS "Item", "wo"."TITLE" AS "Subject", "cri"."FIRST_NAME" AS "Created By", "ti"."FIRST_NAME" AS "Technician", "std"."STATUSNAME" AS "Request Status", "wotodesc"."FULLDESCRIPTION" AS "Description", "sdo"."NAME" AS "Site", "regionDef"."REGIONNAME" AS "Region", "pd"."PRIORITYNAME" AS "Priority", "lvd"."LEVELNAME" AS "Level", "wo"."CREATEDTIME" AS "Created Time", "wo"."COMPLETEDTIME" AS "Completed 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 "DepartmentDefinition" "dpt" ON "wo"."DEPTID"="dpt"."DEPTID" LEFT JOIN "SDUser" "crd" ON "wo"."CREATEDBYID"="crd"."USERID" LEFT JOIN "AaaUser" "cri" ON "crd"."USERID"="cri"."USER_ID" LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID" LEFT JOIN "SiteDefinition" "siteDef" ON "wo"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" LEFT JOIN "RegionDefinition" "regionDef" ON "siteDef"."REGIONID"="regionDef"."REGIONID" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID"="cd"."CATEGORYID" LEFT JOIN "SubCategoryDefinition" "scd" ON "wos"."SUBCATEGORYID"="scd"."SUBCATEGORYID" LEFT JOIN "ItemDefinition" "icd" ON "wos"."ITEMID"="icd"."ITEMID" LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "PriorityDefinition" "pd" ON "wos"."PRIORITYID"="pd"."PRIORITYID" LEFT JOIN "LevelDefinition" "lvd" ON "wos"."LEVELID"="lvd"."LEVELID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" WHERE (wo.ISPARENT='1') ORDER BY 1
Just need to find a way to extract proper date format in the query.
thank you for you help in this matter.
jeff