Not to familiar with Oracle but sometimes dates need to be in '' Try: WHERE dateJoined BETWEEN '#DateFormat(MonthStart,"mm/dd/yyyy")#' AND '#DateFormat(MonthEnd,"mm/dd/yyyy")' Also sometimes you will need the timestamp to grab the entire day for the last day as it defaults to 00:00:00 and it wont grab the rest of the records beyond that time...
'#DateFormat(MonthStart,"mm/dd/yyyy")# 00:00:00' and '#DateFormat(MonthEnd,"mm/dd/yyyy")# 23:59:59' Jeff > -----Original Message----- > From: Torrent Girl [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 19, 2005 12:01 PM > To: CF-Newbie > Subject: RE: HELP (ASAP!!) > > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:989 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
