I am calculating week of the day(ISO) Monday as 1 using the below formula but the 53rd week is appearing what may be the issue?

Question & Answer
,
1

dateDiff(truncDate(‘WK’, truncDate(‘YYYY’, {date})), {date}, ‘WK’) + 1
i used this formula to calculate, please help me with this

2

Depending on the year there could be more than 52 weeks in a year. As you can see there is a little more than 52 weeks so that is why you are getting 53. Are you only getting 53 and not 54?

image
image1418×562 30.9 KB

3

Hi @akashmanjunatha123 ,

Marking @Max 's response as solution. Please let us know if you have further questions.

Regards,
Arun Santhosh