Calculate the Number of Days Between Two Date Fields in Jira

kempili bhargavi

 

 

Business Rule: 

Goal:
Automatically calculate the number of days between the "Date of reception" and "Proposed date" fields.

And the numbers of days between the "Proposed Date" and "Opportunity presentation date"

---

Details:

1. Fields involved:

• • Date of reception (Date field)
  • Proposed date (Date field)
  • Days Difference (Number or Calculated field) to store the result.
    {{}}

1. Expected behavior:

• • If both fields have valid dates, the result will be the difference in days.
  • If either field is empty, Days Difference will remain empty.

1. Automatic update:

• • The calculation will update whenever either date field is changed.

---

Example:

• Date of reception: 2024-11-15
• Proposed date: 2024-11-20
• Days Difference: 5

Same rule will be applied for Opportunity presentation date.

 

Thank you

Vikrant Yadav

Hi @kempili bhargavi  Welcome to Atlassian Community!

Use this smartvalue to get difference between date fields

: {{issue.duedate.diff(issue.customfield_10178).days}}