How to edit the Dates Associated with a closed Sprint

Still need help?

The Atlassian Community is here for you.

Ask the community

Answer

It is currently not possible to modify the Start/End/Complete dates of a closed sprint through the JIRA Software interface. It can only be accomplished through direct modification of the JIRA Software database.

Workaround

Please be sure to back up your database before executing any direct modifications to the database. If you have a testing/staging JIRA Software environment, always test such modifications there before trying them on your live instance of JIRA Software. This procedure has not undergone official testing and may produce unexpected results.

Identifying the Sprint

Navigate to an issue within the the sprint to be modified, then hover over the sprint name under the Agile portion of the issue view screen - the resulting URL will provide the 'sprintID':

Modifying the Sprint

Once you have the ID of the sprint to be modified:

  1. Shut down JIRA Software
  2. Use the following query to change the desired date data:

    UPDATE "AO_60DB71_SPRINT" SET "dateType" = 'timeValue' WHERE "ID" = 'sprintID';

    The 'dateType' value should be modified based on the following:

    dateTypeDescription
    START_DATEThe date/time configured as the sprint's starting date, and the planned date mentioned in Started is getting updated
    ACTIVATED_DATEIf you want to update the Started date in the UI, you have to update the value of ACTIVATED_DATE
    END_DATEThe date/time is configured as the sprint's ending date, and the planned date mentioned in Ended is getting updated
    COMPLETE_DATEIf you want to update the Ended date in the UI, you have to update the value of COMPLETE_DATE

    (info) The 'timeValue' is set in milliseconds. Several online converters, such as Epoch Converter exist to translate from date/time to milliseconds.

  3. Start JIRA Software

Last modified on Nov 3, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.