Timeline for Grouping records based on intervals of time
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 11, 2021 at 5:26 | comment | added | ganders |
Here's mine dateadd(minute, @minIncrement + (datediff(minute, 0, [Start]) / @minIncrement) * @minIncrement, 0)
|
|
| Aug 11, 2021 at 5:26 | comment | added | ganders | @JoeGeeky did you change all 3 instances of the "5" in his example? I variablized mine and it works beautifully! Lol, I just noticed your comment date...whoops! | |
| May 10, 2012 at 17:27 | vote | accept | JoeGeeky | ||
| May 10, 2012 at 13:08 | history | edited | Mikael Eriksson | CC BY-SA 3.0 |
added 690 characters in body
|
| May 10, 2012 at 12:36 | comment | added | JoeGeeky | This provided a nice framework for the answer, but I am still having a little trouble understanding how this works. When I tried to change the offset from a 1 minute interval to a 5 minute interval I still get a 1 minute interval with the whole result starting at a different beginning point. This is very likely because I am misunderstanding how this works. Could you provide one more sample showing an interval other then 1 minute? Thanks... | |
| May 10, 2012 at 6:05 | history | answered | Mikael Eriksson | CC BY-SA 3.0 |