• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1293
  • Last Modified:

Business days caclation in Crystal Reports

I have two fields; date1 and date2. The fields are both formatted as yyyymmdd. What is the formula to take Date1-Date2 to calculate turnaround time for business days only?

Thanks
0
rhopman
Asked:
rhopman
1 Solution
 
mlmccCommented:
Here is a formula for WorkDays
http://www.kenhamady.com/form01.shtml

The number of business hours between 2 dates
http://www.kenhamady.com/form13.shtml

mlmcc
0
 
KedgeboyCommented:
I had to create a similar function to do this calculation too. I needed to know the time between two date fileds.

However I needed to know business time (working time) so that the datediff ignored weekends, bank holidays, knows the opening and closing time of the business so that to see in hours the difference beteween two dates it only counts betweeen 0900 and 1700 on weekdays.

If you need something like this then let me know and I can send you the functions.

Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now