It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Calculated Date Field - Difference between two Dates

Hi,

i use Misc Custom Fields and i want to calculate the Difference between 2 Dates in days.

Date 1 is Customfield 13478, Date 2 is Customfield 13471.

I create an Customfield this these describtion:

<!-- @@Formula: (issue.get("customfield_13471") != null? issue.get("customfield_13471") : 0)
- (issue.get("customfield_13478") != null? issue.get("customfield_13478") : 0) -->

and Type "Calculated Date/Time Field"

and an other with Type "Calculated Nunber Field"

Both Fields are available on the issuescreen. Tested by "Where is my sreen". But i didnt see one of these calculated with the days (Customfield_13471)-(Customfield_13478).

Desired Result an these Example:

(2014/03/24)-(2014/03/01)=23

Thanks for your help!

Best regards

Stephan

6 answers

you may try below one:

 

<!-- @@Formula: issue.get("customfield_13471")==null ? null : (issue.get("customfield_13471").getTime() - issue.get("customfield_13478").getTime()) / 1000 / 3600 / 24 -->

Sonya

  Questions for you....

  Where should I insert that code?  Would you give please help give more details?  The code is some kink of Jira scripting language?

  Thanks

 J.N

hello Stephan Rothämel 

 i want to ask u about this logic i am not clear with this ,can u explain me <!-- @@Formula: (issue.get("customfield_13471") != null? issue.get("customfield_13471") : 0)
- (issue.get("customfield_13478") != null? issue.get("customfield_13478") : 0) --> in which the result of formulla is coming on which custom field means datetime or numberfield .and i am also confused about customfield_13478  this is your custome field name of id how i get this please clear my doubt

Hi Stephan

Are you using jira cloud or jira server . Did you find any solutions for this. I am trying to solve a similar issue.

First, you need to create the 2 date fields you want to play with.

To get the custom field ID, go to your custom field administration and place your mouse on the "edit" button (don't click). On the bottom left corner of your screen you will see the field ID.

To create the calculated field, you need to create a new custom field of the type : calculated number field

In the description you add (please replace the ID by yours):

<!-- @@Formula:
if (issue.get("customfield_13471")==null || issue.get("customfield_13478") == null)
return null;
return (issue.get("customfield_13471").getTime() - issue.get("customfield_13478").getTime())/ 1000 / 3600 / 24; -->

If one of the date fields you used is null, the calculated field will return null so it won't appear on your screen.

Hope it helps

Best

i checked this , im recieving 0 when both fields are empty , so that means this is working , but when it do have date values it do not comes with a value . 

 

I'm using date fields for calculation , not date/time fields

Hi @Constance Hua, I tried everything but this is what the error i'm receiving, can you please help what is pending with this?

Also, looks like when i'm using the formula the getTime() part is getting marked in red is that something is missing?

 

Capture.PNG

 

 

image.png

hi @Prashant Samal,

those fields are not existing as fields. They are just some kind of metadata it seems.

You need to create manually those fields or find their id

Hi There , Any updates on this?

@Constance Hua @Development

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

913 views 14 12
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you