Hi, I have a problem with the rule "weeknum()": evaluated o

Question

Hi,

I have a problem with the rule "weeknum()": evaluated on Monday 4th of January 2016 it returns the week number 2 when outlook (following to my knowledge the norm ISO-8601) indicates 1 for this week. Hence there is a shift for all of the following weeks of the future years (until the next 53rd week, or something like that...)

I understand this is due to considerating or not the 53rd week of year 2015.

Could you tell me if this is a lack from Appian? Is there another standard way to derive the ISO weeknumber?

Thanks in advance!

Victor Bouchery · Answer

Here is the implementation of the rule.
weeknumCustom:
with(
local!weeknum: int(
(
dayofyear(
ri!date
) - userweekday(
ri!date,
2 /* monday to sunday */
) + 10
) / 7
),
if(
local!weeknum < 1,
rule!lastWeek(
year(
ri!date
) - 1
),
if(
local!weeknum > rule!lastWeek(
year(
ri!date
)
),
1,
local!weeknum
)
)
)

Victor Bouchery · Answer

lastWeek: if( contains( /* 53rd week year */ { 2009, 2015, 2020, 2026, 2032 }, ri!year ), 53, 52 )

sindhug0003 · Answer

Thanks, This logic helped us !!