Rolling Dates in Report Builder

[braden_cichinsk]

When I go to select rolling weekly dates it seems to revert to a Sunday to Saturday date range. Is there an easy way to make it Monday - Sunday? I have tried to customise expression and link up via cells but no matter what it seems to always revert back to sunday to saturday. 

Any ideas or am I missing a simple solution :)

[brian_au]

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...

Best,

Brian

[braden_cichinsk]

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 

[warrensander · Accepted solution]

can you calculate the dates you want in excel itself and have them come out the way you want? if so then why not use 'dates from cell' and let excel do the calculations for you.

[brian_au]

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

[braden_cichinsk]

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... 

[devinderbanga]

Hi

I recommends to use formula in excel.

Regards 

Devinder

[braden_cichinsk]

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

[brian_au]

Windows 7- Excel 2013 with RB Version 5.0.5.