Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,007
Community Members
 
Community Events
165
Community Groups

How to Automate Over Due days field ?

Hello everyone,

Here I have a start date and end date of a particular subtask

and also the dates on which the particular subtask is completed 

if you in the example screenshot

in the task is over due by 1 day, this i want to automate

Need to enter the difference of end date and ended date in the over due days field

kindly help

Thanks

YashOver due.PNG 

3 answers

1 accepted

0 votes
Answer accepted
John M Funk Community Leader May 23, 2022

Hi @Yash Raj 

I assume the Over Due Days field is a custom number field - is that correct?

I would create a scheduled Automation rule to run once a day or however often you want it to run.

Add a condition for status != Done

Then do an Edit Issue action to update the custom number Over Due Days field. 

Then in the box for the field value, put in something like: 

{{issue.customfield_17354.diff(now).days}}

Where the custom field is the End date field you are using. 

Hi @Yash Raj 

Yes, and...to John's answer:

Your example seems to show planned Start and End Date and actual Start and End Date.  Is that correct?  If so, you would need to perform that date difference twice for the different pairs of date fields, and then subtract to find the over due days.

Kind regards,
Bill

Like Yash Raj likes this

Hi @John M Funk 

i have tried with your given automation rule

and its comparing the custom field date to todays date and its showing "0" days in Due days field

but i want to compare the actual start and end and if its excides the "No of day to complete" then it should show, how many days it has over due 

Thanks

Yash

This "Number of days to complete" value should minus with the actual start and end 

so that we can see how many days it has dueDue.PNG

Hi @Bill Sheboy 

You are correct

But how to get difference of actual start and end date minus no. of days to complete 

John M Funk Community Leader May 24, 2022

Maybe you could do two different diffs on the dates with results going to two different custom number fields. And then do a a subtraction formula to place the value in a third custom number field. 

Like # people like this

Any example please

Hi @John M Funk @Bill Sheboy 

As per the solution given by you

i have created another number field in which the differnence of the 2 dates is been updating, but the issue here is "its calculation the days but we need the Business days to calculate in the field.

 

another thing as i mention, i want to see the Due days 

for that i have made an automation to edit the Due days field with calculation of

{{issue.fields.Diff.CESD/CEDD.minus(No of days to complete).days}}

it shows it success but no output to be seen

 

Now the first issue is

1. It should Calculate Business days Instead of days

2. Subtraction of two field is not working

 

kindly help me with thisCapture.PNGCapture1.PNGCapture4.PNG

1. It should Calculate Business days Instead of days

is solved now

i have have mention "BusinessDays"instead of days in the smart value

{{issue.customfield_13578.diff(issue.customfield_13579).BusinessDays}}

Like # people like this

2. Subtraction of two field is not working

 

now this also solved

Thanks for support guys

Like # people like this
John M Funk Community Leader May 26, 2022

Great! Glad this is working for you now. 

Like Yash Raj likes this

Hi @John M Funk @Bill Sheboy 

Hope you both doing well

as the above solution 

same i want to implement in the parent task

am able to get the difference of two fields dates but not able to subtract with the "No of days to complete" field.

 

and second thing
i have created the subtask automation with field values and at the same time i have to fill the task field as well..

kindly suggest how to do it

Regards

Yash

Hi @Yash Raj 

Please post images of your rule, and the audit log details when you have a question, including what is not working as you expect.  That will provide context for the community to offer suggestions.  Thanks!

For example, what is different for subtracting the other field using the same methods you have already implemented?

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,375 views 36 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you