[Agile Project Management] Incorrect dates used when Sprints are created

[Agile Project Management] Incorrect dates used when Sprints are created

Forge Component
Published on 2013-03-08 by Nuno Antunes
20 votes
Published on 2013-03-08 by Nuno Antunes
First let me say that this application looks amazing!  Not only will it help me with my project, I know I can learn a lot from it.

I created a project starting 1/1/2015 for 150 weeks (yes, 3 years - insert long boring explanation here) with a Sprint every two weeks.  When you look at the Sprint page, there are 75 Sprints as expected and it shows Sprint 1 starting two weeks after project start which is correct but then Sprint 2 starts in June 2015 and other Sprints continuing on into 2016 and 2017 then it starts again with 2015 dates.  This is definitely unexpected behaviour.

Any thoughts on what happened?  (I've tried it several times with the same results)
Hello Curt,

The problem is that the on the action Project_NewProjectSetSprintDates the initial query GetSprints the Order by used the SprintDescription if your project has more than 10 sprints you would have:

Sprint 1
Sprint 10
Sprint 11
Sprint 2
Sprint 3

and so on, that would mess up the dates has you described.

i Suggest you change the Order By to SprintNr or even SprintId
Thanks!  Knew it had to be something simple just didn't have time to research.