Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Frank Collazo February 12, 2024

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?

2 comments

Comment

Log in or Sign up to comment
Ivan Ferreira February 12, 2024

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.

Custom Charts.png

Frank Collazo April 4, 2024

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

Hermance NDounga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 14, 2024

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. 

 

Like Frank Collazo likes this
TAGS
AUG Leaders

Atlassian Community Events