How is the column closed defined in the database? date or datetime? What dbms are you using? I believe some dbms won't let you compare date to datetime.
-----Original Message----- From: Chris Holdman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 11:35 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Select in Date Range 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] ***************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [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]