10 Replies Latest reply on Nov 6, 2012 2:06 PM by Alex Kerin

    Week Starting on a Monday

    Christopher Turner

      I am trying to compare Yoy by week number and I need to have the week beginning on Monday.  I cannot get both years to display the data in the same way. I was able to get the weeks of both years to begin on a Monday, but 2011 is showing the data on week two instead of week one. Is there some trick to get them in unison.

       

      Week Calculation

       

      DATEADD('day', 1, DATETRUNC('week',DATEADD('day', -1, [transactionDate])))