Calculating the elapsed time between 2 dates

gbanks

Registered User.
Local time
Today, 17:52
Joined
Feb 9, 2000
Messages
161
I have attached a really simple db where in a query I'm trying to determine the elapsed time between A sent date and a received date. Can some tell me what I'm doing wrong? Thanks..
 

Attachments

You're formatting the difference between two dates as if it were a date. That difference is not a date but a decimal number of days.
 

Users who are viewing this thread

Back
Top Bottom