Not able to get return from lookupIssues date diff

Andrew Chan_gcsx1d

I am wondering whether this is a known issues for Jira Automation (Cloud), I was trying to calculate the date difference between epic start date and end date, the below are the illustration of the calculation and issue. 

 

lookupIssues.Start date.min <-- Correct result

lookupIssues.End date.max <-- Correct result

lookupIssues.Start date.min.diff(lookupIssues.End date.max).businessDays.abs <-- NULL

 

Appreciate if anyone can help in this, thanks

Bill Sheboy

Hi @Andrew Chan 

I do not believe End Date is a built-in field.  Did you add that one?

If not, perhaps you mean the Due Date field and could try that one.

Also to confirm you have the correct smart values for the expression, please take a look at this how-to article to find what is supported, including the capitalization and spacing of smart values: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill