Week Starting from monday

[SuperTime]

Is it possible to alter Crystal Reports, so that the weekly function treats the weekly start day as Monday rather than Sunday.
My report needs from Monday to Sunday as the week.


DatePart ("ww", {ApplicationAbandon.Timestamp}, 2)

I tried using the above formula for the group it gives an error " the result of selection formula must be a boolean."

DatePart ("ww", {ApplicationAbandon.Timestamp} , 2) =1

then i used the above formula, but that also does not work


Please advice.

Thanks

 

[lbass]

You are creating the formula in the record selection area--the wrong area. Go to the field explorer (or to insert->formula)->formula->new and enter the datepart formula there:

datepart("ww",{ApplicationAbandon.Timestamp}, 2)

Then you can group on the formula.

-LB

 

[SuperTime]

I now created a formula: @date

datepart("ww",{ApplicationAbandon.Timestamp}, 2)

How do I group on that formula?

 

[lbass]

Go to insert->group and choose {@date} from the dropdown.

-LB