Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: # of days between dates Post Reply Post New Topic
Author Message
pfheg67
Newbie
Newbie
Avatar

Joined: 13 Feb 2009
Location: United States
Online Status: Offline
Posts: 5
Quote pfheg67 Replybullet Topic: # of days between dates
    Posted: 18 Feb 2009 at 1:52pm
trying to do a simple formula of # of days between dates.  Can't get it to work.
 
tried datediff as well as simple formula of
 
{CallLog.RecvdDate} - {CallLog.ClosedDate}
 
also tried a Date as well as CDate prior to each field.
 
relatively new to crystal but this seemed rather straightforward.  haha
Patrick
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 24 Feb 2009 at 1:56pm
How is this not working?  What result are you getting vs what do you expect?
 
Is this the database from the HEAT software?  If so, it's dates are not stored in a standard date format - I believe they're text fields.  Put one on your report to see what it looks like.  If that's the case, you'll have to convert it to a date before you can do date math with it.
 
-Dell
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.014 seconds.