Problem with count of weekdays in CR7

[sbelt]

Hello,

I've been looking in the forum for some helpfull posts, but I haven't been able to find any, so that's why I post a new one.

I want to count the number of weekdays in a period (between {Date1} and {Date2}), so I can see how long it takes a user to make an assignment. Therefore I've made a group on username.

Is there a way to do this?
I'm using Crystal Reports 7.

Thanks in advance!

 

[Thadeus]

Hello,
More information is necessary for someone to help you. Please provide an example of your data.
Are {Date1} and {Date2} separate fields in one record?
OR
Are {Date1} and {Date2} the same field in different records?

I cannot tell this from what you have provided and it will be necessary to helping you...

~Thadeus

 

[sbelt]

I'm sorry for not being clear. I'll give an example of the situation. I hope this can help you:

There are a couple of users who have to make an assignment.

In table 1 the startdates are registered.
In table 2 the enddates are registerd (the date on which the assignment is being uploaded).

I want to calculate how long it takes a user to make an assignment (in weekdays).

Example: Startdate of the assignment is 17-03-2004. The user uploads the assignment on 07-04-2004. It takes 16 weekdays to make the assignment.

 

[rosemaryl]

Dear Sbelt,

I don't have version 7 anymore, but this whitepaper should help you:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_business_days_hours.zip.asp

It has different formula examples for different versions of crystal

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.