wrong calendarweek at date-supplier

  • 1
  • Problem
  • Updated 3 years ago
Hi *,
a user mentioned that there is an error with the calendar-week in the date-supplier.
He is using the Macro: {report-info:value:date(dd-MM-yyyy) 30-12-2015 > w}
As my Outlook and the all the internet-calendars I found said: This is week 53
Our Confluence says: This is week 1

This is not a critical Bug or a Problem but this user is making several diagrams with that data and there are wrong data in it.

Is there any way I can say Confluence the correct week?

We are using Confluence 5.8.9
Reporting 5.2
Confluence Date Time Format is: dd.MM.yyyy, HH:mm
Confluence Date Format is: dd.MM.yyyy
Confluence Encoding: UTF-8

Kind regards
André
Photo of Andre Lehmann

Andre Lehmann

  • 77 Posts
  • 3 Reply Likes

Posted 3 years ago

  • 1
Photo of Mervyn Toh

Mervyn Toh, Alum

  • 117 Posts
  • 7 Reply Likes
Hi Andre,

Can you provide us the storage format of an affected page? You can get the storage format via:
Menu (at the top right corner of the page) > Storage Format

Thank you.
Photo of Andre Lehmann

Andre Lehmann

  • 77 Posts
  • 3 Reply Likes
Hi Mervyn,
here the storage-format:

<p><ac:structured-macro ac:macro-id="65b228b4-44d2-437d-9b1a-08837943fbf0" ac:name="report-block" ac:schema-version="1"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:macro-id="d114d700-2191-40eb-9ff2-428561d0e716" ac:name="report-info" ac:schema-version="1"><ac:parameter ac:name="">value:date(dd-MM-yyyy) 30-12-2015 &gt; w</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro></p>

Hope that helps
Kind regards
André
Photo of Mervyn Toh

Mervyn Toh, Alum

  • 117 Posts
  • 7 Reply Likes
Hi Andre,

I've noticed the year has been set to 2015. Hence, it's showing 1, instead of 53. Here's my storage format:
<p><ac:structured-macro ac:macro-id="65b228b4-44d2-437d-9b1a-08837943fbf0" ac:name="report-block" ac:schema-version="1"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:macro-id="65592cb0-ef11-4d3e-be3c-adcbbf14ef90" ac:name="report-info" ac:schema-version="1"><ac:parameter ac:name="">value:date(dd-MM-yyyy) 30-12-2016 &gt; w</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro></p>
Try it out whether does it work as intended. Thank you.
Photo of Andre Lehmann

Andre Lehmann

  • 77 Posts
  • 3 Reply Likes
Yes it is 2015. The 30th. December 2015 should be the 53rd.week and not the 1st.
Photo of Mervyn Toh

Mervyn Toh, Alum

  • 117 Posts
  • 7 Reply Likes
Hi Andre,

To update you, I've escalate this issue to the developers as a bug. I shall inform you when there are any updates to this issue.

Thank you.
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
Hi,
I have a question about the week number (in 2016):

According to http://www.epochconverter.com/epoch/weeknumbers.php
Week 05 is from Monday February 1, 2016 until (and including) Sunday February 7, 2016.

However, reporting says it's week 06.
{report-info:global:current date > ww}

I believe I have this problem since 2 days ago when I went
To Reporting version 5.7.0 (from 4.3.5) and 
To Scaffolding 7.4.1 (from 5.2.3)

Can you confirm this bug?

Should I compensate with a shift? Or are you going to fix this?
I prefer not compensating with a shift, because it will give me work when you fix it.
But do you have an estimate how long it takes to fix?
Photo of Mervyn Toh

Mervyn Toh, Alum

  • 117 Posts
  • 7 Reply Likes
Hi all,

Great news! Our developers have released a new version of Reporting in regards to this issue. You may upgrade your Reporting to the latest version now.

For more information on this release, you look for more information here.

Thank you.