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:240874
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
