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}}
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}}
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.