Greatly appreciate another set of eyes looking at this please. Picking events from a table based on dates so that only current or future events show up. Date values can not be NULL.
(EventStartDate >= #now()#) AND (EventFinishDate >= #now()#) Let's say an event runs from 17/6 to 19/6 things work OK today but on the 18/6 this event will drop off the calendar even though it's still running. Greatly appreciate any insight - TIA!!!! ++++++++++ Kevin Parker m: 0418 815 527 ++++++++++ http://au.linkedin.com/in/krparker ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
