Forum Discussion
vsinne
8 years agoFrequent Visitor
Real Time Log Question
I have a table where we are tracking ticketing system. Some of these tickets takes longer to finish the job. These tickets may need multiple job to be performed and tracked by time to show how muc...
Phil_Seamark
8 years agoMicrosoft Employee
Hi vsinne
So for the three sample records, what would your expected result be? Is it a DATEDIFF type calculation between the [Date Created] and today (taking into account weekends??)
- vsinne8 years agoFrequent Visitor
Yes i have calculated total time. In my case it calculates total time when ticket has been resolved. if ticket is unresolved in that case it is taking time in the month ticket has been created. So it does not gives actual week data where the job has been performed instead it gives data based on Ticket date creation date.