Change the resolved date on work items in Jira Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian apps on the cloud platform.
Summary
Learn how to update the Resolved Date for Jira work items using a CSV import workaround.
Solution
Follow these steps to update the resolve date for the already resolved issue keys.
Step 1: Export the Work Items to a CSV File
First, export the work items you want to modify into a CSV file, ensuring all fields are included. For assistance with this step, follow the instructions in the article below.
Step 2: Prepare the CSV File
Open the exported CSV file and remove all columns except for Summary, Issue Key, Resolution, and Resolved. This new CSV should only contain these four columns for the work items. Update the Resolved Date in this file as needed. Here’s an example showing how it might look when you’re changing the Resolved Date for two work items.
issuekey, summary, resolution, resolvedate
ABC-1, My test work item, Done, 2025-01-01In the above example, the Date format is YYYY-DD-MM. Jira importer supports JAVA date formats, and you can choose the format while importing the CSV.
Step 3: Access the Import Function
Navigate to settings by clicking on the Gear Icon > System > External System Import, then select ‘Switch to the old experience’ and click CSV on the next page.
Step 4: Upload the Updated CSV File
On the next page, select the updated CSV file with the new Resolved Date and click Next.
Step 5: Choose the Target Project
Choose the project where you’d like to update the Resolved Date for the work items.
Step 6: Map the Fields
On the next page, you’ll see two columns with four fields that need mapping. Map the fields, then click Next.
Step 7: Review and Begin the Import
Review the details and click "Begin Import". You might get a message stating "None work items and projects imported." However, the Resolved Date should be updated in the work items.
We recommend testing this process with a few work items first before proceeding with a bulk change. If you want to update multiple projects, consider updating one project at a time.
If the resolve date format is correct, it imports as specified in the CSV file.
If the resolve date format is not correct, it imports as the current date. Please verify that the CSV file has the same date format.
This option will only work with the External System import, available for Jira admins only.
Was this helpful?