Change Week Start DAY 1

[DBAFrog]

Is there a way to change the default in a crosstab group options WEEKLY on the starting day of the week SUNDAY? Our week starts on MONDAY.
If I can't change it in the defaults, can I do it with a formula??

------------------
Curious by Nature,
Linux by Design

 

[lbass]

Create a formula {@weekstMon}:

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

Use this formula instead of the datefield in your crosstab.

-LB

 

[DBAFrog]

Thanks, works like a charm.

------------------
Curious by Nature,
Linux by Design