G gbanks Registered User. Local time Today, 20: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: 199
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, 14: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.