Custom Week for Grouping

[kpeeler]

We use an odd work week and I need to create reports based on the Thursday - Wed schedule. I am using 8.5 and am trying to modify the following formula to break on Thursday rather than Friday as it does currently (this formula was from the Business Objects support site). My dyslexic brain keeps modifying it such that I get a Thursday and Friday break. Can anyone please help my tired brain, thanks in advance.

if dayofweek({Table.Field}) = [1,2,3,4,5] then
(numbervar x := (-(dayofweek({Table.Field}) + 1));
(dateadd("d", x, {Table.Field})))
else
if dayofweek({Table.Field})=6 then
({Table.Field})
else
if dayofweek({Table.Field})=7 then
(dateadd("d", -1 ,{Table.Field}))

 

[bdreed35]

I think this is what you are looking for:

http://support.businessobjects.com/library/kbase/articles/c2008585.asp

~Brian

 

[kpeeler]

Brian - Thanks for the response. That link is where I got the formula originally - I need help to modify it to result in a Thursday rather than Friday start date.

Thanks - Kevin

 

[mbarron]

Try this one. It moves Sunday through Wednesday to the end of the last week. For example last week would have been July 8 through July 15:

if dayofweek({@date}) in 1 to 4 then
{@date}-dayofweek({@date})-2 else
{@date}-dayofweek({@date})+5

Mike

 

[kpeeler]

Mike - Simplicity is a virtue. Worked like a charm, also helped me understand better how the the DayOfWeek is being manipulated. If I could give you a raise I would - Thanks KP