[thelist] SQL, Dates and more mental health

[Scott Dexter]

I use 

Where (view_date>=dteEvStart and view_date<dteEvEnd)

instead of the between phrase, try that?

sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Ryan Mayberry [mailto:Ryan at applicor.com]
 
> SELECT * FROM tblEvents WHERE view_date BETWEEN dteEvStart 
> AND dteEvEnd
>