Auto fill number field based on date field

[Sagi Gueta]

Hello,

I'm trying making automation (by Jira Automation App) that will set a value on number field based on:

Creation Date [minus] Closing Date

Yet I don't really know how should I make it. 

So far my idea was to make a smart value as shown in attached file, but ofc didn't work :(

What shall I do to make it work?

{{issue.created

[Florian Bonniec · Accepted solution]

Hi @Sagi Gueta 

You have to use diff function for that.

{{issue.closed.diff(issue.created).days}}

You can change the unit as you want, please check the documentation.

Documentation :

https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html

Regards 

[Sagi Gueta]

Thanks for the tip, though I guess I did something wrong..

By the method you suggested to use, it should fill the field with number right? Unfortunately it didn't work when I did it.

[Florian Bonniec]

I think what you want is 

{{issue.resolved.diff(issue.created).days}}

closed will only work if you created the field. resolved is a system field that store the resolution date.

Regards

[Sagi Gueta]

Thanks alot it worked eventually!