Variable-Name for Sprint-Remaining-Time

[Uwe Döll]

Hi, 

i want to compare the estimated duration of my task with the remaining Days in my active sprint and give a warning, if there are not enough days left, to solve the Task. 

My Problem: I don't know how to get the value of the remaining Days. 

this is my Code. I hope someone can tell me the correct name for my placeholder "Sprintremaintime", 

----

with diff = (Sprintremaintime - Estimated_Duration):

IF diff < 0:
""":panel[Warnung]{backgroundColor=red color=white}"""
ELSE:
""":panel[Okay]{backgroundColor=green color=white}"""

----

Best Regards, 
Uwe

[Uwe Döll · Accepted solution]

Seems to be a bigger Problem for the most people. ;-)

I found a solution, that works for me: 

Today is Tuesday. My Testsprint-Ending is set to Friday. Here is my code: 

----

with sprintzeit = DAYS_BETWEEN(NOW(), MAX(sprint.enddate)):

with diff = (sprintzeit - estimated_duration + 1):

If issueType != Epic:(
IF diff > 2 :
""":panel[$diff]{backgroundColor=green color=white}"""
Else If diff > 0:
""":panel[$diff]{backgroundColor=orange color=white}"""
Else:
""":panel[$diff]{backgroundColor=red color=white}""")

----

and this is what i want to see (just the left days of my tasks):