Mon to Sun Week in Cross Tab 1

[Vegasman]

Using CR8.5, is there a way to modify the week in a cross tab from Sun-Sat to Mon-Sun?
Thanks in advance-

 

[lbass]

One way is to use a formula like the following as your column field:

{table.date}-dayofweek({table.date},crMonday})+1

-LB

 

[Vegasman]

That formula seems to work in regards to starting the period on Monday instead of Sunday, but it still seems to end on Saturday. When I select the value to be printed for the column as the last day in the period, it shows Saturdays date instead of Sundays. Any ideas?
Again, thanks in advance.

Tyler

 

[lbass]

To display the last day in the period, change the formula for the column field to:

{table.date}-dayofweek({table.date},crMonday)+7

This formula will change all dates during the week to the last day of the week (Sunday), i.e., there is only one date in the period. You do not need to use the group options screen.

-LB