Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

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

Hi @Angie Affolter 

Take a look at this script here to get started.

Ravi

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"

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Happy New Year and Welcome New Marketplace Partner Program Partners!

Happy New Year! We hope you all had a safe and restful holiday season. 2020 was a unique year full of unforeseen events; however, as we enter the new year of 2021, we’re optimistic for the light at t...

530 views 7 20
Read article

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