How to calculate the hours elapsed between two dates?

[Guest_imported]

I want to figure out how many hours have elapsed between a start date and an end date. How do I do this? I need help!!!! thanks in advance..

 

[KamalKhalil]

Try the Date difference formula:

This will Return the number of date and time boundaries crossed between two specified dates.

Syntax

DATEDIFF(datepart, startdate, enddate)

This example determines the difference in days between the current date and the publication date for titles in the pubs database.
DATEDIFF(day, pubdate, getdate()) AS no_of_days
Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com

 

[twhite5262]

How would you calculate the date differnce including only "business" days mon-friday , excluding Sat and Sun in the total ?

Thanks

 

[kenhamady]

See FAQ 1.B, formula nmber 1.
This formula can also eliminate holidays if you put them into the list. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[savok]

Ken you always mention the FAQ and its sections but where is it? Can anyone post the link to it please?

 

[KamalKhalil]

If you already looking at this page, that means you already passed it.
So, click on the back arrow, to go back one page and look at the tabs in the middle of the page.
One of them is FAQs.
Click on that, and then check the specific item you wish.
In this case it is FAQ 1.B as Ken stated. Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com

 

[kenhamady]

If you go to the main page of any forum (click the forum in your threadminder list) the FAQ button is one of the four tabs at the top, just above the list of questions on each page. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)