nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Forumla for future date

unknown

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!

Accepted answers

Esther Strom

Hi, @[deleted]!

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.)

2023-03-22 12_55_35-Mouse Highlight Overlay.png

All comments

Riley Venable

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.

Esther Strom

Hi, @[deleted]!

2023-03-22 12_55_35-Mouse Highlight Overlay.png

unknown

WOW! That worked! thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud