Forumla for future date

[Dale Thomas]

N00B alert!  :) 

I am trying to find a date that is 6 months before the End Date.   The field I am trying to update would be called 6 Mth Expiration.  

I did review this page. But I am not sure how I reference each field.  

Can someone help me write the value for the automation? 

Thanks! 

[Esther Strom · Accepted solution]

Hi, @Dale Thomas ! 

If you're looking to set the date 6 months prior to a specific date field value (i.e. End Date) when the End Date field value changes, here's what an automation rule could look like. (Note that I'm using fields called Due Date and Planned End Date instead since I already have those fields.)

[Dale Thomas]

WOW!  That worked!  thank you!  

[Riley Venable (Atlas Bench)]

Hi there! To reference the End Date field in your Jira issue, you can use the "{{issue.End Date}}" placeholder in your automation rule. To calculate the date that is 6 months before the End Date, you can use the JQL date functions in the Jira Cloud API. For example, you can use the JQL query "updated <= -6M" to find issues that were last updated more than 6 months ago. To populate the 6 Mth Expiration field with this calculated date, use the "Edit Issue" action in the automation rule and set the value of the field to "{{now(-6M)}}". Hope this helps! Let me know if you have any further questions.