Change Issue Status Based on Date Field

[Kevin Seery]

Hi,

I have a custom field 'Renewal Date" I'd like to change the status of the issue based on this date. ie compare current date to renewal date if within 45 days change status to 'Renew'

Is this possible in JIRA?

Many Thanks

Kevin

[Alexey Matveev · Accepted solution]

Hello,

You can use plugin Automation Lite for Jira. It is a free plugin.

You can define there a trigger which will be a scheduled event. This event regularly will choose issues based on JQL query which you will provide. For example JQL query could be like this "Renewal Date" < startOfDay(-45d). And then you will choose an Action which must be done on such issues. In your case it will be transition issue. 

I think it would solve your problem.

[Kevin Seery]

Hi Alexey,

Thanks for your answer, sounds mad but can use the Add-on due to corp rules.....

Many Thanks

Kevin