You probably have your date format incorrect. Is it in US format (m/d/y) or CDN format (d/m/y) or some other. Also, the quotes might be treating it as a string depending on your db. Best choice here is to use ansi standard dates.
http://www.crossdb.com/dbknowledgebase/differencestable.html Some date information on the differences there. Travis ---- Original Message ---- From: Ben Densmore <[EMAIL PROTECTED]> Sent: 2002-05-03 To: SQL <[EMAIL PROTECTED]> Subject: Using Between operator with dates Has anyone had any problems with using Between and dates? I have a query that you select a range of dates, if I for example do Select * From customerLeads Where TodaysDate Between '04/01/02' And '04/02/02' I get all the 04/01/02 leads as well as the 04/02/02 leads but I also get the 04/02/00 and 04/02/01 leads. I tried using the >= and <= operators but it still does the same thing. Anyone have some ideas as to why the second range of dates grabs the values searched for but also includes the previous years? Thanks, Ben ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
