return remaining days

Harry Varvarigos

Hi, in MS Excel, I can return remaining days by using two values eg., project finish date = June 30, 2023 - todays date (which returns 132 [based on subtracting 30/06/2023 - 23/02/2023). In MS Excel the function is like this: 

=IFERROR(IF(ISBLANK(J2)," ",I1-K2)," ")

Is there a way I can create such a function/macro in JIRA to do this? thanks 

I think JIRA Scriptrunner can do this, but at $19,500 p/a per license! wow! no wonder the share price is through the roof !  

Vamsi Kandala

Hi @Harry Varvarigos

It depends on where you want to get that value.  JQL query or automation rules?

If it is in JQL query, I don't think native Jira supports any functions to get the difference in dates.  But if it is in automation rules, you can use date time smart values as outlined here:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

In your scenario, assign the value '2023-06-30' to a date custom field 'finishDate' and then use:

{{now.diff(finishDate).days}} to get the difference in days between now and the project finish date.

Hope this helps.

Thanks,
Vamsi