Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Automation: when issues transitioned to "Done" display "actual end date" with current date. JQL?

Hi Jira Community,


I'am want to make an automation so that when an issue is transitioned to "Done" it will automatically set the custom field "actual end date" to current date (not due date or target end date, but the actual date it's moved to "Done"). 

My primary question:

- What is the correct JQL?

Supplemental questions:

- Maybe are other easier ways than JQL?

- Finally, should I start learning basic JIRA JQL? (I'am new in the job as a project coordinator in IT - no coding experience).



Here is my JQL, that didn't work:

"fields": {

"actual end date": {now.dayOfMonth}



Audit log regarding the automation that was tried to implement:

"Action details:
Edit issue
Error while parsing additional fields. Not valid JSON."

Screenshots of 'Custion field "actual end date"' automation:
Best regard
Fuji - project coordinator in IT department (project adminitrator in Jira)

2 answers

1 accepted

1 vote
Answer accepted
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 04, 2023

Hi @Fuji Andreas Nielsen 

Why don't you do the following?


Make sure to choose the "Actual End Date" on the field and type {{now}} on its value.

Thats really wierd. Yesterday when I made the custom field "actual end date", it was not shown in the "Choose field to set..." drop-down menu. Maybe it took time to update? I don't know. 

But thanks anyway, I think it will work, or else I will write again. :)

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 04, 2023

@Fuji Andreas Nielsen it doesn't take time to update. It instantly available. But if you created the field on another tab and you had the automation open, then this field will not appear in the dropdown. You would have to refresh your screen in order for the field to appear.

Let me know if you managed it!

It worked. Thank you very much Alex :)

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 04, 2023

Hi @Fuji Andreas Nielsen 

Are you using a Company-managed project (CMP) or a Team-managed project (TMP)?  You can find this information at the bottom-left side of the page in the expanded area.

Where was the custom field "actual end date" created?

The reason I ask these questions is that custom fields can be defined at a global scope for CMP or at a project scope for TMP.  And for CMP the field may need to be added to the views for the project to be accessible to the rule.  Can you see your custom field on the view issue page when you look at an example issue?

Kind regards,

Hi Bill,


It is a company-managed project.

I create the custom field under project setting --> issue types --> just took "date" in the side, and then i renamed it "actual end date". And I think I could see my view issue page at the time, as far as I remember.

I don't know why it was not shown, but maybe Alex (above messages) was right, that i had several tabs open.

Nonetheless, everything works and the automation is active. Thank you very much for your message and your wanting-to-help attitude :)


Kind regards,


Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events