0 Replies Latest reply on May 6, 2014 4:36 AM by Matt Swan

    Changing a reference date parameter to take into account a different start of the week date

    Matt Swan

      Hi there,

       

      I am trying to change the reference date to take into account that the start of the week for my sales data should be a Saturday rather than a Monday.

       

      I have a calculated field to start my week on a Saturday, however, my date reference parameter still works as if the week starts on Monday.

       

      For example, if I set my reference date parameter to 19/4/2014 (a Saturday) I want to see the data for week commencing Saturday 19th. In this case it reports on the previous week.

       

      In order to get the data for 19th - 25th I need to set my reference day two days ahead.

       

      Is there anyway I can get the parameter to match my calculation for Saturday being the start of the week?

       

      Thanks in advance,

      Matt