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 retrieve the total number of days between two dates?

Kalyani Adusumalli

We have two customised date fields ( Date assigned and Date root cause populated )to populate the date ,how do I retrieve the total days spent (time spent )for each defect?

Thanks!

Accepted answers

Vamsi Kandala

Hi @Kalyani Adusumalli

One of the ways to achieve this is to create a number custom field and assign the value accordingly by using:

in the automation rule whenever the 'Date root cause populated' is updated.

Hope this helps.

Thanks,
Vamsi

All comments

Vamsi Kandala

Hi @Kalyani Adusumalli

One of the ways to achieve this is to create a number custom field and assign the value accordingly by using:

in the automation rule whenever the 'Date root cause populated' is updated.

Hope this helps.

Thanks,
Vamsi

Kalyani Adusumalli

Hi @Vamsi Kandala

Thank you for the reply ,Could you please elaborate me on where I can set up the number field and assign this "{{Date root cause populated.diff(Date assigned).days}} in Jira Workflow ?

Is it possible to set up the Filter or Dashboard for the total number of days ?

Appreciate your help!

Vamsi Kandala

Hi @Kalyani Adusumalli

Assume the custom field Ids for the dates 'Date assigned' and 'Date populated' are 'customfield_12345' and 'customfield_67890'
Create a new custom field of type number called 'Days spent' and let its Id be 'customfield_13579', if you have not already created
In the automation rule for the related project, create a new rule and select the trigger 'Field value changed'
In the 'Fields to monitor for changes' option, select the 'Date populated' field
In the 'For' option, select 'Edit issue'
- If you are entering the value for "Date populated' field when creating the ticket, select 'Create issue' also for the above option
Add the 'New action' component and select 'Edit issue'
Select the 'Days spent' field from the list if you see it
- Type in
  {{customfield_67890.diff(customfield_12345).days}}
If you don't see the 'Days spent' field in the list above:
- Click on 'More options'
- In the 'Additional fields' text area, select all and delete the default contents
- Then type in
  {
  "fields": {
  "customfield_13579": "{{customfield_67890.diff(customfield_12345).days}}"
  }
  }
Click on 'Save'
Place the 'Days spent' field in the related 'View screen'

Check and test the automation rule by editing the ticket and updating the 'Date populated' field. The 'Days spent' field should now have the corresponding data.

Hope this helps.

Thanks,
Vamsi

Kalyani Adusumalli

Thank You @Vamsi Kandala !I will keep you updated on the outcome.

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