On Thu, 18 Nov 2004 15:01:58 -0600, Nick Peters
<nick.peters@candoltd.com> wrote:
> 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';
SELECT * FROM transactions WHERE shippingdate> '2004-06-08' AND
transtype='Sale';
Ian Barwick