Having some issues trying to get week #s, week start and week ranges (user created date field) all in sync. Wondering if someone could help assist?
Take a look at this table:
Note how the WeekStart, CalendarDate are inline, but the CalendarWeek, and WeekRange are not.
I believe the issue stems from the difference between Week #s and weekstart, but I'm not entirely sure. I've attached an example QVW.
Is there anyway to resolve this and have them in line?