Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

End date edit of closed sprint

I accidentally re-opened the incorrect sprint and now the complete date is wrong.  Can I change the end date of a completed sprint?

2 answers

Hello Layla, 

You can try one of the two options below:

1 - Go to your sprint report, find the sprint you wish to edit via the drop-down menu. Once you have that selected there's a more options/kabob menu icon (3 horizontal dots) which will allow you to reopen that sprint. At this point, you can then visit your backlog and change the dates of the sprint and then re-close. 

Your current sprint (if you have one active), will remain unharmed, unedited and can continue to feature in active sprint view, upon the close of retro-active sprint.

2 - You can change the end date directly via database:

table -  AO_60DB71_SPRINT


P.S: For the database update, I recommend you to perform it first in a test environment and then perform a backup before implement it on Prod

This will not work as the "complete sprint" button will make the completed date the date you complete it (today for example), and not the date it actually completed on (you do not get an option to choose a completed date). As a cloud customer, it is apparent that we cannot change this completed date, and this is hugely inconvenient as there are several instance where someone has not completed an acceptance in a story, and weeks have gone by and now the sprint velocity is hosed when the work was actually done and is now reported way off. Hope this is addressed in a feature update. 

Like # people like this

Hello @Rick Chabot,

Please, refer that the workaround provided before was for the Server Platform and not Cloud.

For the Cloud platform, you're correct to say that we don't have a way to update the completion date since we don't have database access in Cloud. In fact, the completionDate of the sprints are not editable even using REST API (Refer to this link).

That's why we created the following feature request:

Add ability to change sprint completion date (agile board)

Please, feel free to vote and watch this suggestion to be aware of any new updates.

Like # people like this

Thanks for the reply Petterson, I have voted on the issue. 

You are welcome, Rick.

Have a great day!

Voted for this feature.

Years this has been an issue... Atlassian still has not fixed this. 
I am seriously wondering if atlassian still have any idea on how software project are managed or if they simply dont give a damn about it. 

Seriously sick and tired of their slow, mediocre and overpriced products.

Like # people like this

Is there a way to fix this yet? I have migrated years worth of work from another application to Jira, now it looks as if all of our sprints were completed yesterday since I don't have the option to select an end date when closing a sprint! This makes loads of functionality, such as road mapping, reports etc. completely useless :( 

2018... we are migrating to Azure DevOps now.

Suggest an answer

Log in or Sign up to answer