Calculating days from date/time picker fields

Daniel Schillig

Hello!

My customer has the following requirement:

Changes with a planned downtime of more than 14 days should be labeled.

The fields “Planned Downtime Start” and "...End” are date/time picker fields.

I use the following SmartValue for the calculation, but unfortunately it does not return a value:

 

{{Planned Downtime End.jiraDate.diff(Planned Downtime Start.jiraDate).days}}

 

I output the calculation in the logs:

----

Log

Planned downtime in days: <EMPTY>

----

I also tried to use the custom field IDs with the same result.

Does anyone have any idea where my mistake might be?

 

Thanks and best regards,

Daniel

Bill Sheboy

Hi @Daniel Schillig 

The diff() function takes date or date / time values: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

But, you have added the jiraDate format, which converts the values to text...preventing the diff() from working.  Please try removing that formatting.

 

And...Smart values are name, spacing, and case-sensitive, and often do not exactly match the field names displayed on the Jira pages.  When an incorrect one is used, that returns as null, often leading to unexpected results.

Please use this how-to article to identify the correct smart value (or custom field ID) for your fields before you proceed:

https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

 

Kind regards,
Bill