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 !!