Forums

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

automation: create variable using statusCategoryChangeDate

Dylan Willis
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 5, 2023

I am trying to leverage the duration of time since an issue changed status categories in the creation of a different variable. If we estimate that an issue will take 4 days to complete and the issue has been in progress for 2 days already, I want to capture these variables so that I can see the amount of time left based on our estimates. 

 

I want the below variable to work:

{{issue.statuscategorychangedate.shortDate}}

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Champion
July 5, 2023

Hello @Dylan Willis 

Welcome to the Atlassian community.

Although the field content appears to be a date/time, it seems that the field itself is treated like a string/text in Automation. You need to convert it to a date before formatting it:

{{issue.statuscategorychangedate.toDate.shortDate}}

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 5, 2023 edited

Hi @Dylan Willis -- Welcome to the Atlassian Community!

Adding to Trudy's answer...

If you want to preserve the value for later analysis, consider adding a field to capture Age of WIP, as described here: https://community.atlassian.com/t5/Automation-discussions/What-is-your-most-useful-automation-Here-is-mine/td-p/1560668#M34

This can be modified to measure just business days if you want.

Kind regards,
Bill

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, mindful member, mindful member badge, atlassian community, community kudos, community giveaway, atlassian swag, community values, empathy and kindness, badge challenge, atlassian learning, community engagement, swag giveaway

Earn a Badge, Win a Prize 🎁

Earning the Mindful Member badge proves you know how to lead with kindness, plus it enters you into a giveaway for exclusive Atlassian swag. Take the quiz, grab the badge, and comment on our announcement article to spread the good vibes!

Start here
AUG Leaders

Atlassian Community Events