Time Spent HTML and Query Problems - Need Urgent Assitance
I am trying to produce a custom report in a tabular format with the following headers: Ticket ID #, Requester, Technician, Created Date, Completed Date and Time Spent (Completed Date - Created Date).
However, when choosing the Created and Completed Date this is what I get:
Request ID Requester Technician Created Time Completed Time
3 David Brooks Rose Washak 1156263888921 1156271163156
4 David Brooks Rose Washak 1156266718140 1156269141812
Also the Request ID is not the ticket ID # it is a new created ID #. And I can't get to write the right code to get the time spent which should be completed date minus created date. Could you please help me with this?
Thanks.
However, when choosing the Created and Completed Date this is what I get:
Request ID Requester Technician Created Time Completed Time
3 David Brooks Rose Washak 1156263888921 1156271163156
4 David Brooks Rose Washak 1156266718140 1156269141812
Also the Request ID is not the ticket ID # it is a new created ID #. And I can't get to write the right code to get the time spent which should be completed date minus created date. Could you please help me with this?
Thanks.