Print Page | Close Window

# of days between dates

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5547
Printed Date: 29 Apr 2024 at 5:29am


Topic: # of days between dates
Posted By: pfheg67
Subject: # of days between dates
Date 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


Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window