Ability to use Sprint end dates, in order to edit a date field

Eran Roiter
Contributor
January 15, 2025

Hi all,
I was wondering if any anyone have an idea how can i use some kind of automation to edit a date custom field with the end date of the current sprint ? or for example the end date of the sprint + 14 days for the next sprint.  

When i tried to edit the field with this value nothing comes back  {{sprint.endDate.plusDays(14)}}

 

Thanks ! 

2 answers

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.
January 15, 2025

Hi @Eran Roiter 

What have you tried thus far to solve the need?

 

If you have a rule which is not working as expected, please post images of the complete rule, the audit log details, and explain what is not working as expected.  Those will provide context for the community to offer better suggestions.

 

If you have not started a rule yet, I recommend trying to do so.  Successfully using automation requires learning and experimentation.  To help with that, perhaps first pause to clarify...What you want to accomplish and when you want to do that?

For example, perhaps it is this:

GIVEN a sprint is not started in the backlog
AND the sprint has assigned issues
WHEN the sprint starts
THEN update custom field X on each issue to the sprint's endDate plus 14 calendar days

 

Kind regards,
Bill

Eran Roiter
Contributor
January 16, 2025

Hey Bill,
Thanks for the answer, the automation is running.

Thats what i wrote at the end, the automation is showing no issues, but the field stays empty.

 

Any ideas ?

Thanks !!!

image.pngimage.png

0 votes
Dick
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.
January 15, 2025

Hi @Eran Roiter 
As per Atlassian Documentation on smart-values-date-and-time/  the expression 

{{sprint.startDate.plusDays(14)}}

//returns 2020-08-20T23:27:54.2+0000

I admit, it is the startDate, but looking at the result, this is a DateTime expression. Would your custom field accept that as a date? 

You can break-up your search for what is going on exactly by logging the sprint.endDate and the sprint.endDate.plusDays(14) in your automation. If this also yields results, then you need to format the result to a proper date.

Kind regards,

Dick

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events