Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : 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
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.