why not try a BETWEEN '' and ''
where you fill the '' and '' with the REAL dates...
that will get everything in between, and the ones
that are directly on the date.
rather than just looking at the month, since 1 is less than 12
you can do the between, which follows date rules.
tw
On 5/17/06, Les Mizzell <[EMAIL PROTECTED]> wrote:
> OK, starting with January through September - this works great. It pulls
> up the current month and the next three months worth of events.
>
> <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>
>
>
> But - it won't jump across the year change. So, starting in November
> 2006, for example, it only shows November and December, even though
> there are events in Jan. and Feb. 2007.
>
> Fix is probably easy, but I ain't seeing it right now...
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240873
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
