Crystal Reports # of days between dates

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: # of days between dates

Author	Message
pfheg67 Newbie Joined: 13 Feb 2009 Location: United States Online Status: Offline Posts: 5	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 Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	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
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	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.