Creating Report With Dates Range Split Per Week

building reports webintelligence
18

Got a little problem with this solution. Currently I am putting in a date range of 8th of Dec 2013 to 4th of Jan 2014, which gives me this:

http://i132.photobucket.com/albums/q11/Pichost28/BO_Capture_zpsd3b248d6.png

Trouble is because of the -1 in:

=RelativeDate(LastDayofWeek([Date Object]);-1)

I am picking up the Saturday the 7th Dec date, which I don’t want. When I put in a date range I only want it to pick up the Saturday dates within that range, not before it.

just wondering is it possible to pick up the prompt dates that I am using for my date range, if I could do that I could maybe somehow use this in conditional statement using relative date?

EDIT: This might do the trick:

G

grifter (BOB member since 2013-01-09)