Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,184
Community Members
 
Community Events
168
Community Groups

Can I have a custom field that is the result of comparing two date fields?

I want to compare two date fields (one custom and one delivered) and have the result in a separate field.

Example:

End date (WBSGantt) minus Due Date and the custom field would be the number of days between.

Is this possible?

2 answers

0 votes

You can probaby tweak https://library.adaptavist.com/entity/calculate-the-working-days-between-two-dates a little bit to get it out.

Personally, I'd do it as a "scripted field"

forgive me, I've never done a scripted field, but is what you're saying different from the script Ravi and you mentioned?  Don't I create the 'answer' as a custom scripted field and then attach the script or are there multiple ways we're talking about?

Nothing to forgive, it's a perfectly good follow up question, especially as I've made a mistake!

The script we've pointed at is indeed for a scripted field.  I only glanced at the top bit of it to confirm it was code you might find useful, and assumed it was a post-function that set another field.  It's not, you should indeed paste it into a scripted field definition.

Note that when you create the scripted field, you probably want to set its "searcher" to "number range" and then when you're putting the script in, set the "template" to "number"

0 votes

Hi @Angie Affolter 

Take a look at this script here to get started.

Ravi

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events