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; } } }

Automation to compare Sprint dates with another field

Narsha Bac

Hello Team,

I need some help with an automation. I have to check if delivery date for an issue is within the start date and end date of a sprint (sprint in which the issue is). For e.g, if the issue's delivery date is not within the start date and end date of the sprint (sprint in which the issue is), then the delivery date will be updated to NULL.

The issue is that I cannot check if the date 'is between' the sprint end date. I have only options greater than and less than. Any help on this please?

Screenshot 2024-01-30 094228.png

Also, if an issue is in a sprint but the sprint is not active yet, how will I build the automation please?

Thanks.

Accepted answers

All comments

Bill Sheboy

Hi @Narsha Bac

First thing, there are some limitations to what you are trying:

If an issue has been in multiple sprints, the rule will need to decide which one to use
If an issue is in a future sprint with no dates, what do you want to happen?

Next thing, confirm the type of your custom field. If it is a date picker field you can compare the value directly with no conversions or formatting. That means removing both value from the comparison and the formatting to jiraDate.

If the field is another type, you will need to ensure the values can be compared.

The same methods can be used with the startDate for the sprint.

Kind regards,
Bill

Narsha Bac

Hello @Bill Sheboy ,

If an issue has been in multiple sprints, it will have to take the latest one.
If a future sprint has no date, then delivery date must be updated to EMPTY. For this one, how will the automation check this please?

Thanks for this point, I will do some tests and if necessary I will not convert it.

Another thing is how will I check if the date 'is between' the sprint end date. I have only options greater than and less than. Any help on this please?

Thanks.

Bill Sheboy

Thanks for that information!

Regarding your responses, I see a problem: if an issue was in a sprint and does not finish, and is moved to a future sprint with no dates, there may not be a way to easily know that. You can try the field change smart values for added / deleted values, as my testing indicates they may be working better now than in the past:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#--fieldChange--

For the actual comparison of dates, you could use a Smart Values Condition (previously called Advanced Compare Condition) to test if the Delivery Date is within the sprint boundaries of any sprint found.

This could be done in several ways:

using the field change smart values, check if the Delivery Date is greater than or equal to the startDate AND less than or equal to the endDate
use multiple conditions, one after the other, with the field change smart values
try the same conditions, but use the max and min functions on the sprint field

Narsha Bac

Thanks Bill. I was able to create the conditions and check the values of the sprint end date and Delivery date.

However, I had another question. When and if my issue is meeting my conditions, I want to edit the sprint field with the previous value; let me explain with an example.

Use case: delivery date already specified and sprint is changing from (1) null to ABC, or (2) DEF to XYZ

if delivery date within start and end date of new sprint, i.e. ABC or XYZ
then leave delivery date as-is
sprint = new value of sprint (ABC or XYZ) - This is working fine
else consider as an error (e.g. delivery date = 15-Nov-2023, new sprint dates [01-Dec-2023;15-Dec-2023]
leave delivery date as-is
sprint = previous value (null or DEF)
end if

My question is for the second part. How do I edit the sprint field with the previous value? Previous value could be another sprint or NULL. Is this feasible please?

Thanks.

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-software-cloud

sprint

automation

date

compare