Hey,
I am trying to compare dates in a sql statement. this is what i have tried:
SELECT * FROM transactions WHERE shippingdate>2004-06-08 AND
transtype='Sale';
but it returns all rows. When i switch the > with a < it returns
nothing. I have even tried with todays date and have got the same
resu
Thanks, it turns out that the code that was executing the sql was
flawed. Thanks to all that replied!
-Nick
Ian Barwick wrote:
On Thu, 18 Nov 2004 15:01:58 -0600, Nick Peters
<[EMAIL PROTECTED]> wrote:
Hey,
I am trying to compare dates in a sql statement. this is what i have tried: