nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change the resolution date to the date of the status category change.

Nathália Agostini_shhqkj

There was a recent workflow change on the board, but they forgot to configure the resolution for the "done" status. I made the resolution change, but all the issues that were completed before changing the resolution ended up with "unresolved" resolution. I managed to change the resolution of these issues to "done" through automation.
The issue now is that the "resolution date" shows the date of the automation rather than the date when the card was completed on the board.
How can I change the resolution date to copy the date of the status category change?

Accepted answers

Fernando Eugênio da Silva

@Nathália Agostini , Welcome to the Atlassian Community!

You can change the issue resolution date by performing an Import CSV.

The steps are:
1: Make a filter in Jira and export the issues for which you want to change the resolution date in Jira to a CSV.
2: In this spreadsheet, adjust the date and time you want to apply the resolution date
3: Make a CSV import into Jira with the updated resolution date data.

The main column information you need to have in the CSV is:

Issue Key, Issue Summary, Resolution, Resolved Date

This is sufficient and mandatory information to retroactively adjust the resolved date via CSV.

You can know about Import CSV in Jira by here: Import data from a CSV file | Atlassian Support

Let me know if you have questions.

All comments

Fernando Eugênio da Silva

@Nathália Agostini , Welcome to the Atlassian Community!

You can change the issue resolution date by performing an Import CSV.

The main column information you need to have in the CSV is:

Issue Key, Issue Summary, Resolution, Resolved Date

This is sufficient and mandatory information to retroactively adjust the resolved date via CSV.

You can know about Import CSV in Jira by here: Import data from a CSV file | Atlassian Support

Let me know if you have questions.

Rich Bloch

@Fernando Eugênio da Silva , to follow up on your solution, while I was able to generate an appropriate CSV file, in my case I needed to set a new Resolved Date. However, when attempting to assign the new Resolved Date field in the CSV file to the ticket about to be imported, the assignment option is not available in the droplist. This is true also for the Create Date field. All other fields appear to be available.

From this observation, I'd suspect that both Create Date and Resolved Date are either exempt from change (as part of this CSV import workflow), or there's another problem that I haven't yet identified. BTW, I'm using Jira Cloud (100245).

Thanks for any insight and suggestions.

Fernando Eugênio da Silva

Hey @Rich Bloch

It is entirely possible to change the creation date or resolved date via import CSV.

What you need to consider is making this update via 'Import CSV' in the Jira global interface.

Click on the gear in the upper right corner > Click on 'System' > Click on 'External System Import' > Follow the remaining CSV mapping steps.

This interface opens all available CSV import features into Jira. I just tried to do it and it works as well.

Import Details

Issue details:

Captura de tela 2024-01-15 234843.png

Hope this helps you.

Bjorn Bartlett

Thank you @Fernando Eugênio da Silva , your post finally clarified the solution to this problem for me and I can finally see an accurate 'Created vs Resolved' chart.

Widerlani Campos

edit: sorry I wrote in the wrong place

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud