Business days caclation in Crystal Reports

Posted on 2007-10-03
Last Modified: 2013-11-16
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?

Question by:rhopman
    LVL 100

    Accepted Solution

    Here is a formula for WorkDays

    The number of business hours between 2 dates

    LVL 1

    Expert Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now