Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be prepared. You never get a second chance to make a good first impression
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

28
April

How Do I Calculate the time difference of the values of the same field in Crystal Reports?

During a recent Crystal Reports training session a delegate asked how she could calculate the time difference between the entries of the same field.

Solution:

To achieve this one needs to use the two Crystal Reports functions:
  • Datediff, and
  • Previous

The formula is as follows:

DateDiff("d",Previous({Tablename.Fieldname}), {Tablename.Fieldname})


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

42 + 27 =