Expand my Community achievements bar.

SOLVED

Rolling Dates in Report Builder

Avatar

Level 1

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 :)

1 Accepted Solution

Avatar

Correct answer by
Level 6

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.

View solution in original post

8 Replies

Avatar

Employee

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

Avatar

Level 1

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 

Avatar

Correct answer by
Level 6

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.

Avatar

Employee

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

Avatar

Level 1

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

Avatar

Level 5

Hi

 

I recommends to use formula in excel.

 

Regards 

Devinder

Avatar

Level 1

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

Avatar

Employee

Windows 7- Excel 2013 with RB Version 5.0.5.