G gbanks Registered User. Local time Today, 17:52 Joined Feb 9, 2000 Messages 161 Feb 22, 2006 #1 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 db1.zip db1.zip 7.6 KB · Views: 198
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..
L llkhoutx Registered User. Local time Today, 11:52 Joined Feb 26, 2001 Messages 4,018 Feb 22, 2006 #2 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.
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.