Creating a Week Function

[SunTrustER]

I am using Crystal Reports version 7.0.100.15 going against SQL server, version 7. I am trying to create a "week function" and group and total on that function. The week function would run from Monday to Saturday. For example, I would the report to show 1/8/2001 (Monday) to 1/13/2001 (Saturday). I would want to do a count showing all loans applied for between 1/8 and 1/13 with my grouping title or label showing 1/13. If a loan occurred on Sunday, then spill over into the next week. Then i want to show 1/15 to 1/20 with my grouping title or label showing 1/20 and on and on.

 

[kenhamady]

Try the following formula:

{DateField} - DayOfWeek{DateField} + 7

This will turn any date into the Saturday at the end of that week. I am unclear on what you want to do with Sundays but try this and tell me what you think. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal