Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All-
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?
Thanks!
I think I found it.
In our week# the first day of the week is on Monday
and in your WeekStart the first day of the week is on Sunday
Try :
Week((TempDate)+1) AS CalendarWeek,
This way the Week# also starts on Sunday.