Count down number of days from todays date to field (Stop Date)

Question

How can I create a formula to give me a count down of days from todays date to field (Stop Date)? I'm using attributes in Assets and need to figure out how many days are left on contract from contract stop date.

Today - [Stop Date] = number of days left

Would I used automation, if so, how would I choose the field to set up the formula?

Can I set the formula up in the attribute field?

Frank Collazo · Answer

@Ivan Ferreira Thank you for this but my network doesn't allow third party apps.

Hermance NDounga · Answer

Hello Frank,

I'm not too sure if we can help. Assets and attributes are a feature of Jira Service Management, and I am guessing that it is something you can track there, so if you can't find a way to do it I'd suggest to ask in their group https://community.atlassian.com/t5/Jira-Service-Management/ct-p/jira-service-desk

In Jira Product Discovery, there are formulas, but it's more to calculate prioritization orders and impact scores, so it is not possible to manipulate dates.

Ivan Ferreira_31ou4g · Answer

Hello @Frank Collazo . I think it won't be possible to do it with just custom formula fields, but you could do it with automation.

The problem with automation is that you are limited to 100 issues on the JQL results, and probably you will have a lot of ideas.

Your automation rule should be triggered on a shceuduled basis and run every weekday.

I used these variables in my test automation formulas:

* endDate = {{issue.Objetivo del Proyecto.match(".*end.*([0-9]{4}-[0-9]+-[0-9]+)")}}
* countDown = {{now.diff(endDate.toDate).days}}

Also, you could check the Custom Charts plugin to display "Time Until" in a Dashboard.