[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1289
  • 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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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