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!