Troubleshooting Jira Automation Rule for Date Calculation with Review Frequency

Abdur Rehman_rkrbg4

 

Hi @Stefan Salzl 

 

I am currently working with an object in the IT Infrastructure schema, and I’m trying to update the "Next Periodic Review Date" by adding the "Review Frequency" (integer) to the "Last Periodic Review" (date) field.

 

I have configured the rule as follows and reviewed the audit logs:

{{object.Last Periodic Review Date.plusYears(object.Review Frequency).format("MM/dd/yyyy")}}

The rule successfully retrieves the correct object when triggered, and the values are fetched correctly. However, when using this rule, it returns NULL for the "Next Periodic Review Date". When I manually input plusYears(4) instead of plusYears(object.Review Frequency), it works as expected

 

Could you kindly suggest what might be causing this issue with the smart value?

Thank you in advance for your help

Stefan Salzl

Hi @Abdur Rehman - welcome to the community,

I don´t know the field type of your field "Review Frequency". Even though it holds a number doesn´t mean it´s configured as number or returning a number when used it´s value.

Could you please try the following:

{{object.Last Periodic Review Date.plusYears(object.Review Frequency.asNumber).format("MM/dd/yyyy")}}

 

Best
Stefan