Week number, weekstart and week range issues

[#1]

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!

[Anonymous]

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.