nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smart values date difference using a hard coded value

Manohar Kurapati

Using Jira cloud automation, I am trying to find out the days difference between a value in jira field to the hardcoded date value divided by 14.

Documentation only provides use cases that find the difference between now and date value in Jira field.

{{#=}}{{now.diff(issue.Expected Date).days}} / 14 {{/}}

I am trying to find something like below

{{#=}}{{(08/01/2020).diff(issue.Expected Date).days}} / 14 {{/}}

Please can you help how to get the above working?

Accepted answers

Dario B

Hello @Manohar Kurapati ,

If I understand correctly, you are using automation for Jira Sofware Cloud and you are referring to the below documentation pages:

If that's the case, then a quick way to proceed would be to:

Add a custom field to store the hard-coded date, let's call it HardCodedDate
Fill the custom field with the desired date (e.g. 08/01/2020)
Replace 'now' with the HardCodedDate custom field in the formula you already know:
```
{{#=}}{{issue.HardCodedDate.diff(issue.Expected Date).days}} / 14 {{/}}
```

I hope this helps.

Cheers,
Dario

All comments

Dario B

Hello @Manohar Kurapati ,

If I understand correctly, you are using automation for Jira Sofware Cloud and you are referring to the below documentation pages:

If that's the case, then a quick way to proceed would be to:

Add a custom field to store the hard-coded date, let's call it HardCodedDate
Fill the custom field with the desired date (e.g. 08/01/2020)
Replace 'now' with the HardCodedDate custom field in the formula you already know:
```
{{#=}}{{issue.HardCodedDate.diff(issue.Expected Date).days}} / 14 {{/}}
```

I hope this helps.

Cheers,
Dario

Dionei Piazza

@Dario B , I have a point here.

The example of @Manohar Kurapati is looking for ".days". If the difference between the two dates does not complete a day, is the result 0 (zero) or something like 0.5 days?

Dario B

Hello @Dionei Piazza ,

Sorry for late reply, I am afraid I have missed your comment. However, even if I have never encountered this scenario myself the assumption is that it returns 0.

Also, looking at the example in the documentation (quoted below) I assume that using prettyPrint the function will return the amount of hours as well:

displays the difference in words, e.g.: 2 days 3 hours.

Please let me know if this is something that you still need to know so that, in case it is, I can ask the Automation team for clarifications.

Cheers,
Dario

Dario B

@Dionei Piazza ,

I have asked the automation team and I have been told that it actually depends on the kind of fields:

yes it should display in hours. If both fields are date time fields. If they are just date fields (no time information) then it will likely be 0.

I hope this helps

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud