Grouping by Week 1

[davidlev]

I have the need to group my output by weeks. I have a date field in my data. I'm running version 7.0. Any ideas?
Thanks

 

[mbarron]

Create the following formula then group on it.
{date}-dayofweek({date})+2
//for start day of Monday use +2
//for start day of Sunday use +1 Mike

 

[davidlev]

Awsome! you rock!
Thank you very much!

 

[kenhamady]

Also, when you insert a group based on any date field, you should automatically get the option to set the 'break' to Week, Month, Quarter or Year. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com