Wierd Week

[HowardHammerman]

I need to group payroll data by week. The problem is, my client's week starts on a Monday and ends on a Sunday.
How do I tell the group expert to sort on that kind of week?

I know that there is a place to enter a formula, I just can't figure it out.

Thanks,

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[kenhamady]

Try this method, but make sure you read the warning at the bottom:

http://kenhamady.com/cru/archives/277

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[HowardHammerman]

Thanks Ken,

I should have looked at your site in the first place.

Howard

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[Charliy]

I had to do this a while ago with a week that began on a Tuesday.

I created a formula {@XDATE} with a hard-coded date that was a Tuesday.

Then my formula [@WKGROUP} is DATEDIFF('w',{@XDATE},{table.date})

 

[HowardHammerman]

Interesting,

Charliy's formula yields an integter (week number) while Ken's yields a date, the first day of the week.
Both are very useful.

thanks,

Howard

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com