Forums

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

Jira Automation - date + short text number = date

Holly Robillard March 31, 2023

Hi all, 

I'm trying to use a Duration field (short text) to update my Due date field. The math will hopefully be:

Start date + Duration = Due date

with the Duration being number of days.

Screenshot 2023-03-31 at 11.48.50 AM.png

I've tried the following iterations based on other posts in the community but none of these worked:

{{issue.Start date.plusDays(issue.Duration)}}

{{issue.Start date.plusDays(issue.Duration.asNumber)}}

{{issue.Start date.plusDays(issue.Duration.value.asNumber)}}

Any suggestions?

2 answers

1 accepted

2 votes
Answer accepted
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.
March 31, 2023

Hi @Holly Robillard -- Welcome to the Atlassian Community!

When you note that none of the things you tried worked, what did you observe happening?

Would you please post an image of the audit log details showing the rule execution?  That may provide some context for this symptom.  Thanks!

UPDATE:

I tried this and this worked for me with a short text field:

{{issue.Start date.plusDays(issue.Duration.asNumber)}}

 

Kind regards,
Bill

Holly Robillard April 3, 2023

Hi Bill!

What I was observing happening was that I was getting a successful run of the automation but that the due date field was still empty. I just replaced the line I had with what you've listed above and it worked. I'm still not quite sure why it was giving be a success message with no date update before but I'm happy it's working now.

Thank you so much!

Screenshot 2023-04-03 at 10.09.48 AM.png

Like Bill Sheboy likes this
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.
April 3, 2023

I am glad to learn that is working! 

Smart values are name, spacing, and case-sensitive, so perhaps there was something the rule didn't like.  When something looks like it should work, but it does not, here are a few things to try:

0 votes
Cathy Miller April 3, 2023

When I write up a ticket the due date is present, however once I submit it I can no longer see the due date.  

Would this be something that my development team can add back on the the view or is the due date no longer visible once the ticket is submitted.

2 weeks ago, I was able to see the due date that I placed on each item, now the date disappears upon submission.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events