Rolling Dates in Report Builder

Hi Braden,

You definitely should be able to adjust via the Rolling Dates Weekly option, customized expressions, or cell references. I would make sure you are on the latest version of RB which has numerous options to adjust rolling dates. I would then review the settings in step 1 of 2. Of note customized expressions allow for a preview of the full date range so that might be the best configuration choice.

For example this might work for you for previous week:

FROM: cw-1w+1d

TO: cw

http://microsite.omniture.com/t2/help/en_US/arb/examples_of_date_ranges_using_customized_expressions.html

Best,

Brian

Hi Brian, 

Thanks for replying. I tried that but I am again presented with the same problem. Perhaps if I give more detail.  I am trying to do a 12 week rolling monday - sunday reporting time period. When i used the expression you provided yes the first week started on Monday but it still finished on Saturday. I added in cw+1d but didn't change anything. Any other suggestions?

Cheers

BC 

Hi Braden,

Its difficult to troubleshoot further without direct access to your RB instance, but what you need is possible in my tests on my side. At this point I would raise this issue with Customer Care as it doesn't appear possible that altering the customized expressions would not produce the desired results.

Best,

Brian

OK Thanks again Brian,. Its just bizarre as it always reverts back to finish on Saturday with the custom expression... the expression you provided includes the sunday as well so looks like will have to follow up with client care... 

Hi

I recommends to use formula in excel.

Regards 

Devinder

Hi Brian, 

Sorry to re raise this... I was wondering what operating system are you using as I was wondering if an older version of excel could be the root cause of why the dates aren't working.

Cheers

BC

Windows 7- Excel 2013 with RB Version 5.0.5.