6 Replies Latest reply: Feb 26, 2013 10:13 AM by Danielle van Eeden RSS

    Week vs. Previous Week

    Danielle van Eeden

      Hi All,


      I'm putting together a report where I need to look at the selected week/year and be able to compare this to the previous week, the week before that etc.


      At the moment, I have 2 calendar objects - one for year and one for week. The user will select the year and the week in order to view the results.


      This works fine, apart from over the start of a new year. If I select week 1 2013 for example, I would want the previous week expression to show week 52 2012. However thsi does not seem to work.


      I have tried creating a week-year filed in my script, but can';t seem to get anything to work.


      Any help greatly appreciated!