Inbuilt queries seem to have a date problem?

Inbuilt queries seem to have a date problem?

A number of the queries/reports are failing to run with the error:

Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%d-%m-%Y %k:%i) "Created Time", DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000)' at line 1"

The query is:

select wo.WORKORDERID "Request ID", wo.Title "Title", p.PriorityName "Priority", DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000),%d-%m-%Y %k:%i) "Created Time", DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000),'%d-%m-%Y %k:%i') "Completed Time", wo.TIMESPENTONREQ/(1000*3600) "Time Spent", sd.StatusName "Status", aau.First_Name "Requester", aaut.First_Name "Technician" , qqd.QueueName "Group"

I am unsure what to change. Can anyone enlighten me please as this seems to happen with quite a number of the queries.

Thanks in advance.









                    New to ADSelfService Plus?