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; } } }

update a list field of quarter by a calculated smart value

aya nayman

I have a field of quarter Q124 Q224 ext.

I'd like to have an automation that when an issue is clsosed , the resolution date qill be calculated by a smart value {{issue.resolutiondate.as("qqqYY")}} and put in the list quarter field

I tried using JSON but I keep getting error

Accepted answers

Mohamed Benziane

Hi,

you should achieve this using date format and the format documented here : https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

All comments

Mohamed Benziane

Hi,

you should achieve this using date format and the format documented here : https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

Bill Sheboy

Hi @aya nayman

Please consider: do you have fiscal quarters / years and how do you measure the year start for quarters?

For fiscal quarters / years, remember to adjust the month of the date before performing the calculation.

And for year start, please carefully review the documentation for the format differences for "Y" versus "y" values:

"Y" is the week-based year
"y" is the year of era

For example, on 30 December 2024, "YYYY" will produce 2025 and "yyyy" will produce 2024. Thus the date and format could alter the result as there is variation at the first / last weeks of the year.

Kind regards,
Bill

aya nayman

Hi ,

thank you !! this is the solution for that I have used

{
"fields": {
"Closing Quarter": {
"value": "{{cf}}"
}
}
}

while cf is a smart value {{issue.resolutiondate.format("qqqYY")}}

aya nayman

thank you that was very helpful

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud