I've found several discussions on this topic, but can't seem to get any to work. I have the below code implemented on my system and the 2 custom date fields are filled in, but my new field doesn't show up... @Formula: if (issue.get("customfield_10779")==null || issue.get("customfield_10652") == null) return null; return (issue.get("customfield_10779").getTime() - issue.get("customfield_10652").getTime()) / 1000 / 3600 / 24; --> Some additional details/questions: * JIRA Server * Date Custom Fields are Date (not Date/Time) * Using Custom Calculated Number Field * Custom Calculated Number Field is added to project screen Does the calculation happen automatically / on refresh? Or does it require a transition to take place? Is there a way to easily check what's going on under the hood to see what JIRA thinks the fields are set to so that I can try to understand why the calculation isn't working? UPDATE: It loos like the formula wasn't working because the initial fields were 'date picker' type instead of 'date/time picker' type. Is there any way to use just date? I can't find a good list of possible commands anywhere...

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

Trouble Calculating Number of Days Between Dates Using Jira Misc Custom Fields

Brian Baumgartner

I've found several discussions on this topic, but can't seem to get any to work. I have the below code implemented on my system and the 2 custom date fields are filled in, but my new field doesn't show up...

@Formula:
if (issue.get("customfield_10779")==null || issue.get("customfield_10652") == null)
return null;
return (issue.get("customfield_10779").getTime() - issue.get("customfield_10652").getTime()) / 1000 / 3600 / 24; -->

Some additional details/questions:

JIRA Server
Date Custom Fields are Date (not Date/Time)
Using Custom Calculated Number Field
Custom Calculated Number Field is added to project screen

Does the calculation happen automatically / on refresh? Or does it require a transition to take place?

Is there a way to easily check what's going on under the hood to see what JIRA thinks the fields are set to so that I can try to understand why the calculation isn't working?

UPDATE: It loos like the formula wasn't working because the initial fields were 'date picker' type instead of 'date/time picker' type. Is there any way to use just date? I can't find a good list of possible commands anywhere...

Accepted answers

David Fischer

Hi Brian,

You need to create a custom calculated number field.

As for the formula, it seems correct.

To check for errors, look inside the Jira logfile (atlassian-jira.log).

All comments

David Fischer

Hi Brian,

You need to create a custom calculated number field.

As for the formula, it seems correct.

To check for errors, look inside the Jira logfile (atlassian-jira.log).

Brian Baumgartner

I am using a calculated number field (updated original post). This log is on server as well?

David Fischer

This log is only on server... It's the standard Jira Server logging system (on the Cloud, you don't have access to Jira logs).

Brian Baumgartner

It loos like the formula wasn't working because the initial fields were 'date picker' type instead of 'date/time picker' type. Is there any way to use just date? I can't find a good list of possible commands anywhere...