[thelist] SQL, Dates and more mental health

[Ryan Mayberry]

I tried that already... Doesn't work in the SQL statement, but I can open
all records from the database and use the same logic to loop through the
recordset and then it works perfectly. Except I have to do it in the SQL
statement.

doh...


-----Original Message-----
From: Scott Dexter [mailto:sgd at ti3.com]
Sent: Tuesday, April 03, 2001 2:31 PM
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] SQL, Dates and more mental health


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
> 

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !