Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate dates excluding weekends

Status
Not open for further replies.

ejerblom

Technical User
Joined
Sep 22, 2003
Messages
10
Location
SE
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
 
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.
 
Hi,

Thanks for information. I have tried to find the dll (CRUFLWDAY.DLL) file on but I can't find it. Am I looking at the wrong site?

Regards
Ullis
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top