Unable to capture Difference days between Target Start and Target End date custom fields automation

[Kedareswar]

I am Unable to capture Difference days between Target Start and Target End date custom fields through automation

This scenario i was using to find the days between Target Start and Target End of an Epic to find out and converting into Business hours as 8 hrs. per Day

Any suggestions and solutions will be helpful

[Bill Sheboy · Accepted solution]

Hi @Kedareswar -- Welcome to the Atlassian Community!

First thing, I am using Jira Cloud and not Data Center version of automation.  Please test my suggestions to confirm they work for your version.

Smart values are name, spacing, and case-sensitive.  When an incorrect one is used, they evaluate to null and lead to unexpected rule behavior / errors.

The correct smart values for those fields are: {{issue.Target start}} and {{issue.Target end}}

With Jira Cloud, I recall those advanced roadmap, date fields appear as text (rather than dates) inside of automation rules.  Please try converting them to dates before the diff() call:

{{issue.Target start.toDate.diff(issue.Target end.toDate).days}}

If neither of those works, please try the custom field id for the fields rather than their displayed names.  You may find those custom field ids for your Jira site with this how-to article: https://confluence.atlassian.com/automation/find-the-smart-value-for-a-field-993924665.html

Kind regards,
Bill