How to Automate Over Due days field ?

Yash Raj_qzsyux

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

Yash 

John Funk

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.