thanks barney! >assuming years are irrelevant, the condition for determining if it's >after the start day is like this. > >WHERE (sp_start_month < #month(now())# > OR (sp_start_month = #month(now())# AND sp_start_day <= #day(now())#) >) > >Determining if you're before the end date is equivalent, just >reversed. If both parts are true, you're within the season. If you >need to deal with seasons that cross a year boundary (like >basketball), then you'll wan the inverse comparison (before the start >and after the end). > >cheers, >barneyb > >On 11/8/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: >>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
