Date group - for each week 1

[Katy44]

When I want my data grouped "for each week", how do I change the options so the dates displayed are a different day to the standard, which seems to be a Sunday?

 

[lupins46]

You will have to derive your own week number in a formula field and then group on this.

 

[Katy44]

So I'd have to do

if <date> between <Date1> and <Date2> (where this incorporates Thurs-Thurs)
then "Date 1 - Date 2"
if <date> between <Date2> and <Date3>
then "Date 2 - Date 3"
...etc.for as far into the future as I want to go?

Is there no way to make this a bit more automatic? Surely Crystal must have a setting somewhere for the first day of the week?

 

[lupins46]

No, not that much.

datepart("ww",{mytable.mydatefield})

 

[Katy44]

Thank you for your help.

I'm afraid I don't understand that bit - that formula gives me the week number for the year (1 to 53) how do I then use that to decide whether a date is before or after a Thursday?

 

[lupins46]

Sorry, I lost track of the point of the original Q.

Use:
DatePart ("ww", {table.field},crThursday )

 

[Katy44]

ooh that looks promising, I'll give it a go, thank you

 

[Katy44]

That changes the week number when it reaches a thursday, so I should be able to do the rest using that. Thank you very much!