Percentage between two date-type fields

Question

Hi community, I hope you're doing well.

I would like to know if any of you can help me with a problem that I haven't been able to solve. I need a notification (I'm thinking of using an automation rule) that alerts me when an issue hasn't been updated after 50% of the time between two dates, for example:

Date_Field 1: 26/09/24
Date_Field 2: 01/10/24
Available_Days_Field: 6

The "Available_Days_Field" will store the difference between the two dates. What I need is to be notified when 50% of these days have passed in relation to the date fields, meaning I need a notification on the 3rd day, which would be 50% of 6 days, so on 29/09/24, I would receive email notification early in the day.

I hope someone can help me with this.

Thank you for taking the time to read my comment.
Best regards.

Bill Sheboy · Accepted Answer

Hi @Hector Eduardo Calzada Tenorio

How are you setting the value of "Available_Days_Field"?

If you already have an automation rule doing that, you likely have used the date / time diff() function to compute the value: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

That same function could be used with a rule, on a Scheduled Trigger with JQL, finding issues where the date fields are approaching, and then compute the difference with {{now}} to determine your condition.

To get you started on creating your rule, please refer to these documentation and example sources:

* https://www.atlassian.com/software/jira/guides/automation/overview#what-is-automation
* https://www.atlassian.com/software/jira/automation-template-library#/rule-list?systemLabelId=all&page=1&pageSize=20&sortKey=name&sortOrder=ASC
* https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/
* https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill

Jakub Koc · Accepted Answer

Hi Hector,

I think your issue can be solved but it will require playing with some smartvalues,

Things you would have to set up:

- 2 Date fields for date calculation

- Custom field1 that would hold value of difference between needed date and other custom field2

- Custom field2 that would hold value of original difference between dates

Automation1:
Trigger: Daily at the start of your working day

IF1: If Customfield2 is empty 
- Action: calculate the difference between Datefield1 and datefield2 and put it in customfield2

IF2: IF Customfield2 is not empty

- Action: calculate value at what date user should be notified: (customfield1)

{{#=}} {{customfield2}} / 2 {{/}}

and compare this value to 0

IF2.1: IF value calculated in IF 2 will be 0 or less than 0 then send email notification.

Quick note on that I have tested these as simple automations, haven't really composed them all together so you still might need to check if everything works properly. If you have any questions let me know. Hopefully that will help you:)