you could keep it in... just set it to 11:59 pm on the "oneday" variable.
<cfset today = createDate(year, month, day) /> <cfset oneday = createDateTime(year2, month2, day2, 23, 59, 59) /> (btw, if "year", "month", and "day" are your CF variable names...i'd rename those. those are built in functions in CF and using them as variable names is just asking for trouble) :) On 12/19/06, Orlini, Robert <[EMAIL PROTECTED]> wrote: > I have a search form that searches an Access table w/a date/time field. It > includes date and time (12/19/2006 8:20:07 AM) and I think the time maybe > affecting the search. > > When I pass a search into: > > <CFSET today = Createdate(Year,Month,day)> > <CFSET oneday = Createdate(Year2,Month2,day2)> > > <CFQUERY name="get" datasource="barracuda_log"> > SELECT * FROM message_log_20391 > where timereceived between #today# and #oneday# > > The result is: > SELECT * FROM message_log_20391 > where timereceived between {ts '2006-12-18 00:00:00'} and {ts '2006-12-31 > 00:00:00'} > > When I ask for 12-18-2006 to 12-18-2006, I don't get the desired result. It > displays: {ts '2006-12-18 00:00:00'} and {ts '2006-12-18 00:00:00'} in the > statement, but gives a new records found message. > > How can I get rid of the 00:00:00'? > > Thanks as always. > > Robert O. > HWW > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4