Calculate dates excluding weekends

[ejerblom]

Hi,

I wonder if anyone knows how to solve the following:

I have calculated the hours between a "Reported date" and a "Resolved date". Sometimes the "Reported date" occurs before a weekend and is resolved after the weekend. But the calculationen shall exclude Saturdays and Sundays. How can I exclude the weekends?

For now I have done like this:

DateDiff ("h", {Incident.AZReportedDate}, {Incident.AZ_ResolvedDate})

I would appreciate any help!

Regards
Ulrika

 

[dgillz]

Ken Hamady's website has this one:

http://www.kenhamady.com/form01.html

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[yehong]

You can also use a dll that comes with Crystal or you can download from crystal site. This dll calculates working days for you. dll name is CRUFLWDAY.DLL.

 

[ejerblom]

Hi,

Thanks for information. I have tried to find the dll (CRUFLWDAY.DLL) file on

http://www.crystaldecisions.com

but I can't find it. Am I looking at the wrong site?

Regards
Ullis