Change the dates to a day earlier and a day later ?
Russell Brown
Internet Application Developer
Freeserve.com Plc, PO Box 452, Leeds LS2 7EY
Telephone: 0113 207 1203
-----Original Message-----
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2001 11:48
To: CF-Talk
Subject: OT: SQL Query Help
I don't know if any of you know how to do it but I'm trying to get the SQL
query pasted below to include the two dates, at the moment it doesn't return
data from the two dates specified. ie It returns queries starting Jan 02 and
ending 19 Feb....
:-(
SELECT DateAdded, EmailA
FROM eShot
WHERE ( DateAdded
BETWEEN '2001/Jan/01'
AND '2001/Feb/20' )
AND EmailA LIKE '%@%'
AND ConfCode LIKE '%cc0243%'
ORDER BY DateAdded
All I can say is: HELP!!!!
Any and all comments would be most gratefully appreciated.
-= Ed
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
