Thanks ... For some reason, the next day (after I sent this), the query started working properly. I didn't change a thing. It just started working.
H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -----Original Message----- > From: Bryan Love [SMTP:[EMAIL PROTECTED]] > Sent: Friday, November 09, 2001 1:06 PM > To: CF-Talk > Subject: RE: (sql) Between -- date range > > to_date() converts a string to a date type in Oracle. The mask specifies > the how Oracle should pick apart the string. If you use to_date() on a > date > field it will err. > > > > > Bryan Love Macromedia Certified Professional > Internet Application Developer / Database Analyst > Telecommunication Systems Inc. > [EMAIL PROTECTED] > > > "What father would hesitate to say 'if there must be trouble let it be in > my > day, that my child may have peace'?" > - Thomas Paine, An American Crisis > > > > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 08, 2001 11:48 AM > To: CF-Talk > Subject: Re: (sql) Between -- date range > > > Howard, > I'd suggest throwing the same to_date format around the column name, so > that > you're sure that you're comparing apples to apples. The default oracle > date > format is dd/mmm/yyyy, so that might be your issue. > -Deanna > > > So: > to_date(SellDate, 'mm/dd/yyyy') BETWEEN TO_DATE('#form.StartDate#', > 'MM/DD/YYYY') AND > TO_DATE('#form.EndDate#', 'MM/DD/YYYY') > > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
