Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
the report always shows data from the current week and then from the next week and the one after that, up to 12 weeks in the future.
(KW = calendar week)
In the report, the employee can select the year and the calendar week in selection box.
So I use for the next Week:
GetFieldSelections([MASTER_CAL.Week])+1
For the week after:
GetFieldSelections([MASTER_CAL.Week])+2
then +3, +4, ...+12
But now the year ends in calendar week 52 and it shows week 53 instead of 1.
How can I adjust the formula so he knows a new year is about to begin?
In the calculations I use:
Sum({1<[WPL.Week] = {"$(=[MASTER_CAL.Week]+12)"}, [WPL.Year] = {"$(=Year(Today()))"}>}[WPL.Capacity])
Can you help me please? 🙂
Unfortunately I have to ask again:
Does anyone know how I can add calendar weeks when a new year is coming up? 😔
Like:
Current Calendar Week is 49.
[CalendarWeek]+1 = 50
[CalendarWeek]+2 = 51
[CalendarWeek]+3 = 52
[CalendarWeek]+4 = 1 (new Year)
I can't handle the turn of the year.