Right smart Value to get the diff date

[Mar Angelo L_ Tareno]

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.

[Walter Buggenhout]

Hi @Mar Angelo L_ Tareno,

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 Angelo L_ Tareno]

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? 

[Joseph Chung Yin]

@Mar Angelo L_ Tareno -

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