How can i get ISO Week number in calculated column

Question & Answer
, ,
1

If i any logic like below
Weeknum({order_date}), dateDiff(truncDate(‘WK’, truncDate(‘YYYY’, {order_date})), {order_date}, ‘WK’)+1 …

the week is starting from sunday , can we change it to Monday.

Simply how can i get week numbers based on ISO standard(where week starts on monday)
from sep 2, 2024 to sep 8,2024 is 2024-36 where monday starts

2

Hi
by changing the setting of analysis you can get the desired result.

image
image322×653 20.8 KB

3

Thanks, It worked well

1 Like