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 ! :)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.