We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Date/Time Difference in Crystal Reports
Posted on 2010-09-01
I'm creating a report in Crystal Reports XI in which I want to measure the difference (in hours) between two date/time scenarios. One issue is that I'd like to measure business hours only. The other issue is that the dates and times are currently in two different fields. I've used the date difference formula before, but I don't know how to work it for the above issues. Has anyone done this before?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Herre is a formula to calculate the workdays
http://www.kenhamady.com/form01.shtml
Here is a formula for workhours
http://www.kenhamady.com/form13.shtml
mlmcc
http://www.kenhamady.com/form01.shtml
Here is a formula for workhours
http://www.kenhamady.com/form13.shtml
mlmcc
Active 1 day ago
> The other issue is that the dates and times are currently in two different fields.
Two different fields (in the same record), or two different _records_?
Two different fields is the easy one, so I'm guessing that you really meant two different records. How you handle that may depend on the structure of your data and report. The simplest thing would probably be if you could change the data so that both datetimes were included in the same record (in two separate fields, of course). For example, maybe create a view or use a CR command (a query that you create manually) that pulls the two datetimes into one record.
James
Two different fields (in the same record), or two different _records_?
Two different fields is the easy one, so I'm guessing that you really meant two different records. How you handle that may depend on the structure of your data and report. The simplest thing would probably be if you could change the data so that both datetimes were included in the same record (in two separate fields, of course). For example, maybe create a view or use a CR command (a query that you create manually) that pulls the two datetimes into one record.
James
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month2 days, 1 hour left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.