I'm looking to create reports with the date stamps, but no timestamps, or to at least hide the timestamps in the reports. Putting them in a separate column would work as well. We are using SQL Server. Here is my current report query, but I'm not sure where to edit this to display only the dates.

SELECT wos.ISOVERDUE "Overdue Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",ti.FIRST_NAME "Technician",qd.QUEUENAME "Group",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",wo.TITLE "Subject",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueBy Time",longtodate(wo.COMPLETEDTIME) "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 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 SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE  ((((((wos.ISOVERDUE = 1) OR (wo.TITLE LIKE N'%New Employee Setup -%' COLLATE SQL_Latin1_General_CP1_CI_AS)) AND (wo.TITLE LIKE N'%New Employee Setup -%' COLLATE SQL_Latin1_General_CP1_CI_AS)) AND (qd.QUEUENAME = N'Customer Support, IT' COLLATE SQL_Latin1_General_CP1_CI_AS)) AND (scd.NAME = N'Profile - New' COLLATE SQL_Latin1_General_CP1_CI_AS)) AND (((longtodate(wo.DUEBYTIME) >= 1420099200000) AND ((longtodate(wo.DUEBYTIME) != 0) AND (longtodate(wo.DUEBYTIME) IS NOT NULL))) AND ((longtodate(wo.DUEBYTIME) <= 1451635199000) AND (((longtodate(wo.DUEBYTIME) != 0) AND (longtodate(wo.DUEBYTIME) IS NOT NULL)) AND (longtodate(wo.DUEBYTIME) != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1

Thanks,

Steve