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.
We recommend testing this process with a few work items first before proceeding with a bulk change. Additionally, temporarily disable or modify any automation rules that might interfere with the bulk update process, such as SLA recalculations or notifications. If you want to update multiple projects, consider updating one project at a time.
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, 01/01/2025 10:15 amIn the above example, the Date format is dd/MMM/yy h:mm a. Please specify the format that dates are stored in the CSV file. Please use syntax valid for SimpleDateFormat.
The date format you type in the CSV must match the format you select during import. If the format does not match, the import silently sets the Resolved date to the current date instead of the value in your file.
This option will only work with the External System import, available for Jira admins only.
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." Do not treat the message as a failure — it is expected for this workaround. Confirm success by opening one of the imported issue keys and checking that its Resolved date now shows the value from your CSV (not today's date). If it shows today's date, your CSV date format did not match the import format — correct the format and re-import.
Was this helpful?