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?

Views: 42

Reply to This

Replies to This Discussion

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...

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service