How to automate caculating incrementally a Date Picker field within linked issues?

[Duc Anh Le]

Hi all,

I have a requirement for incrementally caculating the date for issues with linked issues.

Details:

There are 3 fields named "Start Date", "End Date" and "Duration". User is only allowed to input Start Date and Duration in the beginning (Issue A). From that, End Date will be generated (sum of Start Date and Duration).

Whenever links to another issue e.g issue C, "Start Date" of issue C will be caculated based on "End Date" of A +1 and "End Date" of C is caculated based on "Start Date" of C + 4. So on for C links to E.

The diagram below illustrates the flow.

Is there any relevant scripts or ways to achieve this kind of requirement? 

Many thanks

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Duc Anh Le

Quick question do you expect the Start Date and End Date alteration to take place only in one direction?

For example, if the outward link of A is C, i.e. A causes C, and only C is updated, will A not be affected?

Thank you and Kind Regards,

Ram

[Duc Anh Le]

Yes it takes place in one direction @Ram Kumar Aravindakshan _Adaptavist_ 

Kind regards,

Anh