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; } } }

How to work out the date Difference

Matthew Hardy_rf2x5b

Hi,

Just looking for some help.

What I am wanting to do is work out the Number of days a quote has been submitted for against the current date.

I have a custom Field set up called (Date Quote Was Submitted By Brexons).

With this we would then like to automatically work out how many days on a rolling day to day basis it has been submitted.

Example:

Date Quote was submitted (03/01/22)

Todays Date (06/01/22)

Number of Business days (3) - This would then go up in value as each day passes but only for business days.

Would this be possible to do and if so, any help to achieve this would be greatly appreciated.

Accepted answers

Marco Brundel

Hi @Matthew Hardy ,

With a automation rule it is possible I think.

I've made a rule for the difference between two fields and uses the following in additional fields:

{

    "fields": {

        "Time To Market":<span> </span>"{{#issue.customfield_11500}}func=businessDaysBetween({{issue.customfield_11501}}), format=\"toDays\"{{/}}"

    }

}

Is this useful to you?

Regards, Marco

All comments

Marco Brundel

Hi @Matthew Hardy ,

With a automation rule it is possible I think.

I've made a rule for the difference between two fields and uses the following in additional fields:

{

    "fields": {

        "Time To Market":<span> </span>"{{#issue.customfield_11500}}func=businessDaysBetween({{issue.customfield_11501}}), format=\"toDays\"{{/}}"

    }

}

Is this useful to you?

Regards, Marco

Bill Sheboy

Hi @Matthew Hardy

Adding to Marco's idea, you could do this for time-to-current date/time with this:

Please check your field name to confirm the smart value. And, this assumes business days are Monday to Friday, 9am to 6pm.

Kind regards,
Bill

Matthew Hardy_rf2x5b

@Bill Sheboy @Marco Brundel

Thank you both for your response.

Sorry I am new to this. To achieve this would I need to create another custom field for the number of days to go into?

Further more, which trigger would be the best one to use when creating the automation rule and then for the action would it be "Comment on Issue"

Again thank you both for your help and sorry to be a pain.

Bill Sheboy

Hi @Matthew Hardy

What do you want to do with that value for the number of days? For example, if you wanted to report/filter on it, you could calculate it with an automation rule and then store it in another custom field.

Regarding the rule trigger, you could check on a change to your "Date Quote Was Submitted" field, such as:

trigger: your date field changes
action: edit issue to store the calculated days in another custom field

Here are some automation references and examples to help you get started:

If you have challenges doing this, please post images of your rule and audit log so the community can help.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud