Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Calendar in my load script that has been edited to start weeks on Monday. This script:
Dual(Year($1), YearStart($1))&'-'&Dual('W'&Num(Week($1,0),00), Num(Week($1,0),00)) as [YearWeek];
Is outputting the 1st week of 2023 as a week only containing the day 1/1/23. How can I change it to make the first week of 2023 to start on the first Monday of this year, 1/2/23?
Thank you
I see one parameter named broken_weeks in the week function if it can help you in some way -