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

[Angie Affolter]

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?

[Ravi Sagar _Adaptavist_]

Hi @Angie Affolter 

Take a look at this script here to get started.

Ravi

[Nic Brough _Adaptavist_]

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"

[Angie Affolter]

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?

[Nic Brough _Adaptavist_]

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"