Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Subtracting Two Dates in the same field Post Reply Post New Topic
Author Message
KMendels
Newbie
Newbie


Joined: 24 Feb 2012
Online Status: Offline
Posts: 14
Quote KMendels Replybullet Topic: Subtracting Two Dates in the same field
     Posted: 05 Jun 2012 at 9:57am
Easy part - I would like to subtact two dates from each other to see how many days have elapsed between the two dates.
 
Hard part - these two dates belong to the same field.  DateDiff seems to require two different fields to subtract.
 
Example:
 
Case #     Code    Date 3
FSP1        A105    4/16/2012
FSP1        A110    4/22/2012
 
How can I subtract the 4/16/2012 value from the 4/22/2012 value?


Edited by KMendels - 05 Jun 2012 at 9:58am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Jun 2012 at 10:10am
datediff('d',{table.date3},next({table.date3}))
IP IP Logged
KMendels
Newbie
Newbie


Joined: 24 Feb 2012
Online Status: Offline
Posts: 14
Quote KMendels Replybullet Posted: 05 Jun 2012 at 10:29am
Perfect!  Thank you!!!
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.