update a list field of quarter by a calculated smart value

[aya nayman]

hi 

 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 

[Mohamed Benziane · Accepted solution]

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

[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")}}

[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]

thank you that was very helpful :)