Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Time Diff between Two Records Post Reply Post New Topic
Author Message
HEMREDDY
Newbie
Newbie


Joined: 31 Jul 2013
Online Status: Offline
Posts: 38
Quote HEMREDDY Replybullet Topic: Time Diff between Two Records
     Posted: 25 Nov 2013 at 5:04am
Hi,
 
Below is the data that i have obtained through crystal reports 2008.
 
Load #               Time
 1234            Max Time 11/24/13  8:59:54
                    Min Time   11/24/13 8:18:06
 
1239             Max Time 11/24/13  9:35:54
                    Min Time 11/24/13   9:10:06
 
1295             Max Time 11/24/13 10:11:54
                    Min Time 11/24/13   9:48:06
 
How can i get the time difference between the two loads. Time diff will be Max Time from previous record minus Min Time from the next record.
 
Is this posiible.
 
Thanking you,
 
Hem Reddy
IP IP Logged
jwilliams
Newbie
Newbie


Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
Quote jwilliams Replybullet Posted: 25 Nov 2013 at 7:08am
you can try a Datediff
 
Datediff("H",{min time},{max time))
 
H=Hours
N = Minutes
D = Days
 
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.