2 Replies Latest reply on Jun 24, 2010 1:00 PM by FM9NewUser

    Elapsed Time Calculation



      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!