On May 17, 2007, at 11:24 AM, Gary Strommen wrote: > WHERE issueDate between #dateMinNew# and #dateMaxNew#
Does it change if you do: WHERE issueDate > #dateMinNew# and issueDate < #dateMaxNew# I only ask because I've never done 'between'. Have you tried a simpler query that only does less than or more than? Does it help if you use cfqueryparam to designate type, either as a date/time or timestamp? Have you output the SQL to see what it's actually querying? > Now that I think about it, I think I have found the problem. Could > it be because in the DB, my issueDate column is told to be > formatted as "Text" and not "Date/Time"? Oh yes - wish I had read that first. Yeah, it's probably that. In Oracle/SQL, you can do to_date(): http://www.techonthenet.com/oracle/functions/to_date.php an example: to_date( '2006/01/01','yyyy/mm/dd') AS new_date I don't know if that applies to other SQL versions, but if not there's probably something similar. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2747 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
