Issue field: Days since creation as a number

Marc Parsons

Hi, trying to run a basic gadget / dashboard showing # of issues at 0-30 days old, 31-60, >60. 

Have tried the standard gadgets and fields, but none do this pretty common and basic function. 

Tried custom issue field "Days since Creation" (Text and number formats) and used automation script to run daily: 

{{issue.created.diff(now)}} This works but places it as a complex text string and will not add it as a number (of days) in the number formatted field at all. Filters cannot use this format in terms of "days" calculations either. 

Likewise filter scripts seem to be oriented at time in terms of looking back from now vs counting from creation. 

How can this be done? 

Bill Sheboy

Hi @Marc Parsons -- Welcome to the Atlassian Community!

What do you mean by:

{{issue.created.diff(now)}} This works but places it as a complex text string and will not add it as a number (of days) in the number formatted field at all.

To get the number of days difference between created and now in an automation rule, remember to include the units of measure for days.  This will allow storing the result in a custom, number field.

{{issue.created.diff(now).days}}

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

 

Kind regards,
Bill