Forum Discussion
decarsul
5 years agoHelper V
Weeknum wrong
Gday all, As some / most here have already stated / noticed, for us europeans (according to iso 8601) the weeknumber for 2021 is wrongly calculated. In fact, the thing that worries me more is tha...
decarsul
5 years agoHelper V
Thanks for the suggestion.
However, i've reverted and am still testing to Weeknum(date,21).
So far, this seems to be working. With the exception that week 53 of year 2021 is at the end of each visual, instead of the start.
Payeras_BI
5 years agoSolution Sage
Hi decarsul ,
When you say "week 53 of year 2021 is at the end of each visual, instead of the start", I think you mean the first three days of 2021 belonging to week 53 of year 2020.
If this is the case you can get them at the top of your visual tagging them as 2020 instead and sorting by Year Week (2020-53 would come first than 2021-01).
ISO Week number:
ISO Year:
Regards,