I need to update "Due date" to have the same date as "Current Finish date"; How can I do that?

[Alam Nur-ul]

Hi

I want to update "Due date" to have the same date as "Current Finish date"; How can I do that?

Is there anyway, we can use the "bulk change" of issues where "due date" field is empty?

[Jack Brickey]

Two ways I would suggest 

1. use a Post function in the workflow transition to your closed status to set the due dat field
2. use automation to trigger on the transition to closed status and set the duedate to the current date

[Alam Nur-ul]

Hi Jack,

thanks for the prompt answer. However, can you elaborate re: how to use "post" function in the workflow, please? Also how to trigger 'automation'; can that be done using JQL?

I have 300 issues which required to have the "due date" same as the "current finish date"; So I was looking for option in "bulk edit". I was thinking to use "Change Due Date" field to equal the "Current Finish Date".

If you can give some examples or screen shots, that will be much appreciated.

Regards   

[Alam Nur-ul]

Thanks to all of you. Really appreciate it.

I'll definitely try it out and let you know. this 'Automation for JIRA - Lite'  would be excellent help for me, I suppose.

[Haddon Fisher]

Bulk update won't work, since you are copying a value and not applying the same value across all of them. An export\import could work, but seems a little heavy. I am with @Jack Brickey re: Automation; use the 'Automation for JIRA - Lite' since it's free and has the functions you need to solve this very quickly:

1. Use the 'Scheduled' trigger and set it to some high number so it won't accidentally trigger. In the JQL section, give it the JQL to identify the issues you need to change.
2. Add a 'Condition' that the key equal one of the keys returned by your search. This for testing - you will remove it after you confirm it's set up correctly.
3. Use the 'Edit Issues' action, and tell it to set the value of the 'Due date' to 'Current Finish date'.
4. Save and execute your rule. You should see the correct value in 'Due Date' in the one issue you identified in step 2. If you don't, re-check your logic. If you do, proceed with step 5.
5. Delete the 'Condition', save, and execute your rule.
6. Disable the rule so it doesn't fire again in 90 days.

[Jack Brickey]

Don’t need to use Lite as the full version is now integrated with Cloud OOTB. In fact A4J/lite isn’t available in marketplace for cloud.

[Haddon Fisher]

Thanks for the correction @Jack Brickey , did not know that but glad to hear it!

[Bert Dombrecht]

Hi Alam,

If this is a one-off correction, you could do this with an export and import.

1. Create a filter with all issue that need to be corrected (Due date is empty)
2. Add the columns you need:

• Issue Key
• Summary
• Current Finish Date

3. Export (csv, current fields)

4. Use the export file as an import file and map the Current Finish Date to the Due Date

• Also map the Issue Key, so the existing issues are updated (instead of new issues being created)
• Also map the Summary (this is mandatory for import)

Note: you might have to do some modifications to make sure the export date format matches the import date format (reformat in the file before import, or set the format in the import configuration).

I would advise to do this in a Test environment if possible, to make sure everything works as expected, before performing in Production.