Forum Discussion
Previous week calculation
Hi everyone, Iam calculating the total number of previous week to have change week over week with code below, but in the result it shows same number for every weeks. PreviousWeekCount = VAR Cu...
I have table calendar here, I still can calculate change in Weeknumber with code above (i guess because it is number), but i wanna display in Weekdisplay (text), so if i apply for Weekdisplay with same code, just change weeknumber = weekdisplay it did not work.
Please help, thank you guys.
week numbers won't work reliably across year boundaries. Safest approach is to subtract 7 days or to divide the day number by 7.
