Calculating Turn Around Time 1

[KizMar]

I have a report I'm creating where I'm pulling a check in date (start date) and check out date (end date) that are datetime fields. What's the best way to calculate the turn around time (time lapsed between in and out) within Crystal (8.5)?

 

[chris777]

The easiest way is to use the DateDiff function in crystal. Create some variables to hold the different values of day, week, month, hr, etc. and then concantenate them as a string output (or date if you need the value later) Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[kenhamady]

I prefer:

EndDate - StartDate Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[KizMar]

Thank you both. =)