Summary report showing strange dates

Summary report showing strange dates

I have created a summary report of all tickets by technician. We have only had Servicedesk Plus since last December, 2016 but I get results showing data from December of 1969. Very strange. Any ideas on why that is occurring?

I have attached what the output looks like. Here is the SQL query that the report generator created:

SELECT ti.FIRST_NAME AS "Technician", ti.FIRST_NAME AS "Technician", longtodate(wo.RESOLVEDTIME) AS "Resolved Time" FROM WorkOrder wo 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 WHERE (wo.ISPARENT='1')  ORDER BY 3 NULLS FIRST 

I was trying to create a summary report that would let me choose which month to display but I haven't quite figured that piece out. I was just trying to get this as a starting point.

Any help would be appreciated.

Tim

                  New to ADSelfService Plus?