You may need to quote your dates. WHERE dateJoined BETWEEN '#DateFormat(MonthStart,"mm/dd/yyyy")#' AND '#DateFormat(MonthEnd,"mm/dd/yyyy")#'
I don't know how youe particular database/driver handles them, but it might take 2/1/2005 as 2 divided by 1 divided by 2005... -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: 19 May 2005 17:01 To: CF-Newbie Subject: RE: HELP (ASAP!!)[Scanned] When I use the following in query: WHERE dateJoined BETWEEN #DateFormat(MonthStart,"mm/dd/yyyy")# AND #DateFormat(MonthEnd,"mm/dd/yyyy")# I get the following error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected DATE got NUMBER >Shouldn't have to remove the timestamp- DateFormat() will take a >Datetime object. What's the error, and are you receiving the error >with the code as written, or when you pass a different datetime object >than the Now() function? > >Matt Osbun >Web Developer >Health Systems, International > > >-----Original Message----- >From: Torrent Girl [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 19, 2005 9:49 AM >To: CF-Newbie >Subject: RE: HELP (ASAP!!) > > >THANKS! that worked > > >How do I remove the time stamp? > >I get an error when i add dateformat. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:988 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
