The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Right smart Value to get the diff date

Mar
Contributor
September 21, 2024

Is this the right smart value to get the difference between creation date and the date of Change status for Specific status ?

 

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

 

I need to get the count of days after changing the status between date created and date status change.

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote
Walter Buggenhout
Community Champion
September 22, 2024

Hi @Mar,

Could you explain what you are trying to achieve? I get a feeling that there may be an easier way to accomplish what you need than the way you are trying to solve this. 

Mar
Contributor
September 22, 2024

Hi, I need to get how many days spend before the status changes from date of creation to change of status.

does the smart value correct? 

Like # people like this
0 votes
Joseph Chung Yin
Community Champion
September 22, 2024

@Mar -

In smartvalue, when you try to get two date field (it is my understanding) the unit used must be actual date field.

Your smartvalue usage of "issue.statusCategoryChangedDate" is not correct because it is a JQL function - See this reference page - https://confluence.atlassian.com/jirakb/how-to-search-using-statuscategory-statuscategorychangedate-function-with-jql-1115669437.html

From the smartvalue reference page - https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/, it clearly stated that units are referring to date unit/field.

Hope this helps.

Best, Joseph Chung Yin

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events