1 Reply Latest reply: Apr 4, 2012 9:09 AM by Dennis Hoogenboom RSS

    Week number, weekstart and week range issues

      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:

       

      Table.jpg

      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!