Help with project automation

[MA Tianchi]

Hi Community,

I want to automatically calculate how many days has an issue been created. 

What I've done is to create a field called "创建日期" (sorry in Chinese) which automatically pick the date of when this issue was created. And now I'd like another field to always calculate "the date of today" minus ”创建日期“.

How to set the automation to achieve it?

Thanks a lot.

[Ollie Guan]

Hi @MA Tianchi ,

pls refer to this kb

https://community.atlassian.com/t5/Jira-questions/Automation-to-calculate-days-between-dates/qaq-p/1546709

[MA Tianchi]

Hi Ollie, 

Thanks for the reply, but what I want is not to calculate the difference between today and the issue created date, I want to calculate the difference between today and one specific field which is in date format. How can I make it? 

Thanks!

[Ollie Guan]

Hi @MA Tianchi ,

how about this?

https://community.atlassian.com/t5/Jira-Software-questions/Date-calculation-in-Jira-automation/qaq-p/1906556

[MA Tianchi]

Almost there..I put like this: {{now.diff(issue.fields.创建日期).days}}

But the result is a negative value. How can I reverse it to positive?

[MA Tianchi]

Hi Ollie,

I want to tigger the automation every 5minutes, but when I set the trigger, there is an error. How can I correct it?

Thanks!