smartvalue diff for Plan "Target end" to Plan "Target start" returns NULL days

[Daniel Shukrun]

I use a Manual trigger to test the following Automation rule:

Log message: days differance: {{issue.customfield_13081.diff(issue.customfield_13080).days}} days

In the Audit Log I get:

days differance: days

Seem like the calculation return Null value.

customfield_13081 is Plan Target end field and customfield_13080 is Plan Target start field.

Any experaince/advice with this diff calculation - eventauly I need the diff to be an intiger days value

[Bill Sheboy · Accepted solution]

Hi @Daniel Shukrun 

I believe the planning smart values are text and not date (or date / time) types when used in rules.  They must be converted with the toDate function before using the diff() function:

https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html#Jirasmartvaluesdateandtime-Convertingtexttodates

Please try this expression:

{{issue.customfield_13081.toDate.diff(issue.customfield_13080.toDate).days}}

Kind regards,
Bill

[Daniel Shukrun]

Awsom - works. Thanks