How do I translate an ISO week string to a date value?

Question

Hi,

Working with project automation on Jira Server. My use-case is to translate an ISO week string '2053' (i e 2020 w53) to a date.

Field 'Progress Deviation Comment' contains string '2053'.

However, my translation results in date '2020-12-27' (Sunday of w2052) instead of the expected date of '2020-12-28' (Monday of w2053).

Testing indicates that toDate("yyww") use Sunday as first day of week and w2053 and w2101 results in same date:

* String '2052' ->  '2020-12-20' (Sunday of ISO week 51) 
* String '2053' ->  '2020-12-27' (Sunday of ISO week 52) 
* String '2101' -> '2020-12-27' (Sunday of ISO week 52)

Doing a check of week number using my locale of Sweden shows the expected week 33.

I suspect adding locale is required for proper translation to ISO Week date, but I am unable to find any documentation on how to do this translation. Does anyone know?

Best Regards

//Jimmy

François Dumas · Answer

@Jimmy Petersson, I have exactly the same challenge.  Did you solve it in the end?

Bill Sheboy · Answer

Sorry that didn't work for you, Jimmy.

At this point, I suggest having your site admin submit a ticket to support to see what they can find in the logs (...the ones we cannot see): https://support.atlassian.com/contact/#/

Then please post back here so the whole community can benefit.  Thanks!

Until you hear back from them, have you tried a work-around of adding a day with plusDays(1) or toBusinessDay() for the Monday?

Jimmy Petersson · Answer

Hi Bill and thanks for the suggestion.

I tried adding convertToTimeZone to my expression (needs locale("sv") in order not to fail rendering in project automation).

Convert IO_WEEK_NUM to date: {{issue.Progress Deviation Comment.toDate("yyww").locale("sv").convertToTimeZone("Sweden/Stockholm").jiraDate }}

But there is no value output:

LogConvert IO_WEEK_NUM to date:

So I did not manage to convert to an ISO WEEK number using convertToTimeZone() function.

B R

//Jimmy