_date) - TO_DAYS(order_date) AS days_elapsed ...
--jeff
- Original Message -
From: "Brandon McCombs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 13, 2002 8:34 PM
Subject: date subtraction error
> Hi,
>
> Maybe I'm missing somethin
Hi,
Maybe I'm missing something but I tried solution someone posted for
someone else's problem concerning finding out # of days between 2 dates.
I have 2 sets of dates I'm working with in my sample DB.
order_date completion_date
2002-07-03 2002-07-09
and
2002-06-27 2002-07-08
Now the query
