AnsweredAssumed Answered

Elapsed Time Calculation

Question asked by FM9NewUser on Jun 24, 2010
Latest reply on Jun 24, 2010 by FM9NewUser


Elapsed Time Calculation




I am a fairly new user to FM 9 and am having issues with calculating elapsed time.


I have 4 fields:  Referral Date; Referral Time, Pickup Date; Pickup Time. All fields are set up as Date or Time fields.  To find the time between the referral and pickup, I tried the following that I found on an earlier posting:


Timestamp (Pickup Date; Pickup Time) - Timestamp (Referral Date; Referral Time)


All I get is "?".  Can someone please tell me what I am doing wrong?  BTW, the time can be greater than 24 hours.


Thank you in advance for your help!