Jira Automation - Smart value: Difference between 2 timestamp custom fields in a 3rd custom field

[Anand Chittoor]

Hello, 

Looking for some help here. 

I have researched many community solutions (by @Ravi Sagar _Sparxsys_ , @John Funk, and @Nir Haimov  but still stuck at the last hurdle.

I have the following custom field's below for which automation is working fine. These are timestamp fields.

I want to populate another custom field (number) Time to First Reponse (TTFR), which is the difference between the "Acknowledged timestamp" and "Ready status timestamp", ideally in businessDays. Hours will work too if need be.

I have tested my automation conditions trying to hard code the TTFR edit issue to a number (2). and it populates fine. But when I insert the below formulae, the automation log shows success, but there is nothing outputted in the TTFR field.

-Formulae i have tried under "edit issue" 

• Acknowledged Timestamp - customfield_14475,
• Ready Timestamp - customfield_14474

{{issue.Customfield_14474.diff(issue.customfield_14475).hours}} 

or

{{issue.customfield_14475.diff(issue.customfield_14474]).businessDays}}

SCREENSHOTS - 

[Nic Brough -Adaptavist-]

This is not strictly accurate, but for your purposes you can think of a Jira Data Centre installation as being a Jira Server install. 

Start at https://confluence.atlassian.com/adminjiraserver/migrating-from-jira-cloud-to-server-applications-938846963.html

[Shrikant Maheshwari]

Thanks Nic for replying.

So you are suggesting first to migrate to JIRA server and then to upgrade to JIRA DATA Centre.

Cant we migrate directly from JIRA cloud to Data centre.

[Nic Brough -Adaptavist-]

Yes, you can, you can just pretend the DC install is a server.