Closed Issue Date

[James_Styles]

I have been asked to figure out how to pull the "closed date" for issues.  The idea is that they want to be able to pull the data into a CSV to do some analysis.  Currently, we are only able to see the time, but no dates.

[Petter Gonçalves · Accepted solution]

Hello James,

The resolved field displays the date and time an issue was resolved, although it uses relative dates on JIRA UI (e.g: "5 hours ago").

That being said, you can export your issues using CSV including the resolved field, by performing the steps below:

1 - Navigate to the issue navigator and create a filter with all the issues you would like to export

2 - using the List view, add the resolved field together with all the other fields you would like to export in the CSV under the columns menu

3 - Click on the download Icon > Export Excel CSV (Current fields)

Let me know if these instructions work for you.

[Arunkumar Chandran]

Thanks for the info @Petter Gonçalves !

Is it possible to create a query to display the issues closed in last one week?

(Am able to get this data by manually providing the dates in query like " project = xxx AND issuetype=YYY AND resolved >= 2021-08-28 AND resolved <= 2021-09-04". But how to get this info dynamically without manually entering the dates every week?)

[Symantha Gates]

Did you try the variable like startOfWeek?

For example, I search based on Labels = XYZ and resolved >= startOfWeek() and then I get all the items closed this week