Need to be able to convert a date comparison to a number value

Joe Harmon_y3pgen

I am not sure that where I am going wrong on this is in the date section.  I am trying to create a formula that will return a value based on the following formula.

Priority = (revenue/365)/(goal date - today)

Here is what I have but I am getting an error when the formula tries to calculate.

revenue = issue.get("Incremental Revenue")
days = 365
goal = issue.get("Goal Date")
today = new Date().format("yyyy-MM-dd")
if (revenue == null) return null;
if (revenue == 0) return 0;
if (goal == null) return null;
return (revenue/days)/(goal-today)

I am using a jira calculated field from JMCF 

David Fischer

The problem stems from the fact that you are converting "today" into a String. It should be a Date, just like "goal". In that case, the "-" operator between two Date objects will return the difference in number of days.

Also, I'm not sure what you're calculating, but don't you want to multiply by the number of days between now and the goal date instead of dividing?

def revenue = issue.<span>get</span>(<span>"Incremental Revenue"</span>)
def days = <span>365</span>
def goal = issue.<span>get</span>(<span>"Goal Date"</span>)
def today = new Date()
<span>if</span> (revenue == <span>null</span>) <span>return</span> <span>null</span>;
<span>if</span> (revenue == <span>0</span>) <span>return</span> <span>0</span>;
<span>if</span> (goal == <span>null</span>) <span>return</span> <span>null</span>;
<span>return</span> (revenue/days)/(goal-today)