I just happened to have some code open... SELECT blah.... FROM tblCalendar WHERE EventDate BETWEEN #CreateODBCDate(someStartDate)# repeat AND #CreateODBCDate(someEndDate)#
The start and end dates can come from your form values... With CFQueryparam of course. ;) HTH G! On Thu, Dec 17, 2009 at 10:06 AM, Damo Drumm <[email protected]>wrote: > > Hi im having some bother trying to get a search by date range working on a > form in coldfusion. does anyone have any tips on setting this up? > It would be greatly appreciated > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
