Good Morning
I have a report I would like to design to how long an agent takes on an incident from approving it to the next agent in a workflow.The current table only store the created and modified dates any ideas how can split the time to show how long an incident stays with an agent in days or hours?
Tags:
Hi Joseph.
Some SQL functions you can look at regarding working with dates are as follows and could help working out time-frames, extracting different parts from dates and converting dates to different formats:
https://www.w3schools.com/sql/func_sqlserver_datediff.asp
https://www.w3schools.com/sql/func_sqlserver_datepart.asp
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-conve...
Hi Joseph.
If you need some more information on using the Connector module. You can find some helpful learning videos here:
http://learning.sageintelligence.com/sage-evolution-advanced/visual...
© 2018 Created by Sage Alchemex.
Powered by