nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adjust custom date field based on custom numeric field?

Bud Herz_4dzuwt

Illustrious and knowledgeable community, I have this question:

Pre Reqs:
Custom date field called QA Start Date

Custom numeric field called ST Review time est

When Sprint starts, automation looks at sprint end date and back dates the QA Start Date field based on number entered in the ST Review time est field.

Question:
What is the best way to accomplish this?

Reason:
QA needs to establish transparently how much time we estimate is needed for the ST review to ensure Scrum Master is pushing the Devs to deliver in time for QA to finish within the sprint.

Accepted answers

Bud Herz_4dzuwt

Everyone was very helpful. I'm thankful for that. Our project runs two sprints and we could not solve it pulling a date from some previous sprint as an end date.

If we execute the process during Sprint Planning it's accurate enough for what we want to do.

I solved this by moving the calculation to be based on 'now' + number of days
Example: {{now().plusDays(2)}}

So it branches for each calculation between 1 and 9.

Trigger = ST Review time

Add certain number of days to current date

set the resolved date to field Qa Start Date

Example:

Date is 6/4/2025

ST Review time est = 3

Calculate {{now().plusDays(7)}}

result: QA Start Date = 6/11/2025

All comments

arielei

Hey @Bud Herz

Please explain your condition:

Trigger = Sprint Starts

Look for the sprint end date

add the ST Review time est to the value.

set the resolved date to field Qa Start Date

Example:

sprint end date : 15/06/2025

ST Review time est = 3

result: Qa Start Date = 18/06/2025

Is this what you need?

Ariel.

Bud Herz_4dzuwt

@arielei - yes that is what I am looking to solve. I suppose to be completely clear it would be like this? --

Trigger = Sprint Starts

Look for the sprint end date

subtract the ST Review time est from the value.

set the resolved date to field Qa Start Date

Example:

sprint end date : 15/06/2025

ST Review time est = 3

result: Qa Start Date = 12/06/2025

arielei

Hey @Bud Herz

So build to following automation, from global automation:

Trigger: Sprints Starts

Branch on: For Each: issues in the sprint

Edit work-item:

field = Qa Start Date

Value = {{sprint.endDate.minusDays(issue.customfield_10287)}}

** Replace the "10287" with your custom field number.

you can also add logs if you want to view the runs.

Screenshot 2025-06-02 at 18.40.02.png

Bud Herz_4dzuwt

@arielei YESSSS this works! I had been chasing it with
{{CreatedSprint.endDate.minusDays(issue.customfield_12345)}}

Could you help me fine tune this for a current sprint?
-- I just tested it on some samples and found the tickets that rolled over and include previous completed sprints will subtract from the previous sprint end date, not the current sprint.

Much appreciated to get us this far though. Thank you.

Bud Herz_4dzuwt

Everyone was very helpful. I'm thankful for that. Our project runs two sprints and we could not solve it pulling a date from some previous sprint as an end date.

If we execute the process during Sprint Planning it's accurate enough for what we want to do.

I solved this by moving the calculation to be based on 'now' + number of days
Example: {{now().plusDays(2)}}

So it branches for each calculation between 1 and 9.

Trigger = ST Review time

Add certain number of days to current date

set the resolved date to field Qa Start Date

Example:

Date is 6/4/2025

ST Review time est = 3

Calculate {{now().plusDays(7)}}

result: QA Start Date = 6/11/2025

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

planning

dates