An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
12 days, 20 hours 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 today
> 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
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month12 days, 20 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.