Broken weeks

[sanjujeeboy]

Hi All,

im using broken weeks concept where iam showing Dec-28-2020 to Jan-03-21 as Week 53.

but when im doing Weekyear , Jan 1st to 3rd is showing as 53-2021.

i want to show it as 53-2020

how can i acheive this?

@Kushal_Chawda @sunny_talwar 

[martinpohl]

Can't help because

weekname('01/01/2021')

returns 2020/53

Regards

[andykrst]

maybe u can using weekstart to get the first date on that week and using Year() after that.

week(date)&'-'&year(weekstart(date))