You might want to test the boundary cases because the time portion of datetimes can cause trouble for you.
Adrian -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 18 May 2006 05:28 To: CF-Talk Subject: Re: ARGH! - Three Months in the future query problem Duh! This does it: WHERE event_date < #threemonths# and event_date >= #startDATE# See! Getting away from the computer and thinking about things while walking your dogs really helps!! > <cfset startDATE = #now()#> > <cfset threemonths = DateAdd("m",3,startDATE)> > > <cfquery name="calendar"> > SELECT > id, event_date, event_name FROM events > WHERE month(event_date) >= #month(startDATE)# > and event_date < #threemonths# > and year(event_date) >= #year(startDATE)# > ORDER BY event_date,event_time ASC > </cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240876 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
