Right smart Value to get the diff date

Question

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

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

Joseph Chung Yin · Answer

@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

Mar · Answer

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?

Walter Buggenhout · Answer

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.