Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can't help because
weekname('01/01/2021')
returns 2020/53
Regards
maybe u can using weekstart to get the first date on that week and using Year() after that.
week(date)&'-'&year(weekstart(date))