Also, if you intend to search through 12-15, move your date to midnight 12-16.
At 11:34 AM 2/10/2003 -0600, you wrote:
Okay I know this should be easy but I am not having any success. I want to select betwee two dates. Here is my query, what am I doing wrong.<cfquery datasource="date" name="name"> select * from request where closed between '2002-10-01 00:00:00' AND '2002-12-15 00:00:00' order by closed </cfquery> Christopher V. Holdman [EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]