Forum Discussion
Solved
Average Time between rows
Hello, I've looking through the forum and I can't find the answer, so I'm asking my particular case. I have a simple table with 2 columns: Name, ReportedDate. I need to make a measurement with the...
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)