Date of close issue

Hi All,

we need a custom field which shows the date/time of the close of an issue. I know that the History tab shows the close issue date for each issue but we need the export a report which results the close date for all the issues.

How can we do that?

Thank in advance


3 answers

1 accepted

2 votes

Create a Date custom field and capture the current date in the post function of Close transition using the JIRA Suite Utilities plugin (Update Issue Custom Field Value).

Is it a date custom field or a date time field? Did you try both? Also check the version of the plugin. I have used it in the past but not in the latest versions.

Hi Jobin,

somehow it doesn't work:

I insterted %%CURRENT_DATETIME%% but it failed to update the field value.

I didn't find a tutorial for this plugin.

Can you please help?

Hi Jobin,

now it works! Great!

The only problem that it set the field only in now...

do you know asolution which set the custom field in the past transitions also?

You know: the requesters need to do a monthly report tomorrow and needs these infos back from 1 month ago

Thanks again!


well, you cant do that with this approach. You will have to find the date and fix it in DB!

how do you mean fix it?

You will have to add an entry for the customfield in the customfieldvalue table.

Hi Jobin,

I discussed with our system admin but he has no idea how to put an entry in the DB.

Can you please hint?

Why "Resolution date" standart field is bad?

That captures the date of resolution. Closed Date is the date when the issue is closed I guess? That is a different transition.

yes, Jobin has right: the resolution date is logged generally when the is RESOLVED.

I need the date captured when the issue is created.

Hi Rumi,

Could you please let me know how you got the post function to update custom field with %%CURRENT_DATETIME%%  work finally?. I added this post function to a transition  to Closed status, but the status did not get updated. I am using On Demand version of JIRA.


image2015-6-3 14:40:17.png

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,127 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot