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

Question

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 !

Eran Roiter_tdmgcu · Answer

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 !!!

Bill Sheboy · Answer

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

Dick · Answer

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

//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