Changing The Default First Day Of Week

[CIBS]

Hi

Using - CR 9

I have a date parameter and a cross tab table that displays call for each week what I want is to change the user to be able to choose the date range (NO PROBS HERE) But also choose what day should be the starting day for the week as things are grouped.

Or is there a way that for example if the user puts the starting day as the 19th September 2009 (Saturday in the UK) then in the table the first week group will be 19th september and not the 20th September 2009 (Sunday in the UK)


what I have to bare in mind is that the user pay pick one week in time or they may pick a range

Any help is as always appriciated

Kind Regards

Stephen

 

[CoSpringsGuy]

group on a formula like this

int(
({date_from_database} - {?firstdate})
/ 8)

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

You could use the following:

datepart("ww",{table.date},dayofweek({?StartDate}))

If the data can cross calendar years, you might want to have an outer group on {table.date}->on change of year.

-LB