Automation: Find the date difference between now and end of a sprint?

Michael Haywood

Goal: Send a weekly automated message that says how many days are left in the sprint.

Attempt to Solve:

{{now.diff(issue.created).weeks}} works great as spelled out in the documentation.

However, I'm unable to get a result when I'm trying to access the sprint end date of an issue.

Below is my workflow

I get a value for {{now}} and I get a value for {{lookupIssues.get(0).customfield_100016.endDate.jiraDateTime}}, but the 3rd audit log value that is doing the date diff is blank.

I tested doing {{now.diff(lookupIssues.get(0).created).weeks}} and it properly returned a value. 

So why can't the Sprint End Date be used for the date diff?

Or is there a better way to reach the goal?

Bill Sheboy

Hi @Michael Haywood 

The sprint field in issues is a list field, containing 0-to-many values.  Please try getting the specific entry you need.

If your current sprint has the latest date, you may find the difference for an example issue in the lookup issues result with this:

{{now.diff(lookupIssues.first.sprint.endDate.max).days}}

For the first issue in the lookup result, this will check all possible assigned sprints for that issue, finding the one with the largest end date value, using it for the diff() with now.

Kind regards,
Bill