Difference between the two dates, calculated in days

[kalaimani]

Hello Community

My task involves calculating the difference between two dates: one is the issue creation date, and the other is a custom field that automatically populates when the issue transitions to 'Done.' How can I calculate the difference between these dates and, based on the number of days, update the value in a custom field?

We don’t use Add-ons here

[Samuel Gatica _ServiceRocket_ · Accepted solution]

Hi @kalaimani 

You can utilize automation to achieve this.

Please refer to Date difference {{[date1].diff([date2]).[unit]}} 

Example:

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

Hope this helps!

Best regards

Sam

[kalaimani]

Yes ,I tried it same way but i could not get as i expected.Can you help me with this.

[Samuel Gatica _ServiceRocket_]

Hi @kalaimani 

Could you please provide a screenshot that displays the details of your automation? Thank you.

Best regards

Sam

[kalaimani]

Hi @Samuel Gatica _ServiceRocket_ 

Test Date 2 is my custom field .

So, in my custom field, the difference in days between issue creation is automatically used to select the dropdown values.

For Example :If the difference between Test Date 2 and the issue creation date is 1, the automation will select dropdown value 1.

[Samuel Gatica _ServiceRocket_]

Hi @kalaimani 

Here is an example of how to update the dropdown field based on the outcome of the date difference calculation.

Hope this helps!

Best regards

Sam

[kalaimani]

Yes, it works for me. Great! Thanks for your help.

• Here What is meant abs ? 
• If we have a small number of options, this method works. But if I have 200 dropdown values, is there an easier way to handle it?

[Samuel Gatica _ServiceRocket_]

Hi @kalaimani 

• ABS(expression), Returns the absolute (non-negative) value of the expression
• You can directly assign the result in the Select field as follows:

{{Test date.diff(issue.created).days.abs}}

Best regards
Sam

[kalaimani]

Great !! Yes its working .

Thanks again @Samuel Gatica _ServiceRocket_ 

[Simon König]

Hi, without addons my suggestion is you could use Jira automation with smart values. Look them up here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/

And for SmartValue regarding date and time: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

You can cast any field-value as a smartvalue and then add them.

[kalaimani]

Thank you sharing the Documents