Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difference between two dates

Status
Not open for further replies.

LV

Programmer
Nov 1, 2000
1,184
US
I need to get the difference between two dates (in DateTime format) and it should read like this:
5 days, 10 hours, 33 minutes

Is there any function returning the difference between two dates in "DD, HH, MM" format or I need to write a formula calculating all this?
 
Are you using SQL, or directly a Crystal Report? Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
 
Kamal Khalil: thanks for the reply.
I found a UFL on Crystal site, comparing two datetime values and returning the value in "DD,HH,MM,SS" format, which is exactly what I need. The file's called ufldtdif.exe.
Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top