Forum Discussion
Average Time between rows
See this article:
You will want the column that uses the EARLIER function. At that point you can create another column that calculates the difference in hours or minutes and then you should be good to go.
See this article:
You will want the column that uses the EARLIER function. At that point you can create another column that calculates the difference in hours or minutes and then you should be good to go.
Thanks for your help.
I'm trying to reproduce it in my case.
I'm having another error with this part: DATEDIFF([ResolvedDate],NOW(),SECOND)
ResolvedDate column has this data.
ResolvedDate
| 1/22/2018 6:07:13 PM |
| 1/22/2018 6:11:13 PM |
| 1/23/2018 4:11:30 PM |
| 1/22/2018 6:12:01 PM |
| 1/22/2018 6:11:44 PM |
and the error message is this: In DATEDIFF function, the start date cannot be greater than the end date. How this is possible?
Yeah, DATEDIFF can be a pain:
DATEDIFF(NOW(),[ResolvedDate],SECOND)